Archives of the TeradataForum
Message Posted: Thu, 19 Sep 2002 @ 13:06:29 GMT
Right. CASE ... END is an expression, not a statement. However, in V2R4.1, there is also a case statement (CASE ... END CASE;), which can be used only in stored procedures, not macros. See the SQL Reference, Vol. 6, ch. 4, p. 4-43.
Now let's review....
Expressions always have a value; statements do not (not in SQL, anyhow). Expressions do not do anything; statements do something (they are commands). Expressions can be terms in larger expressions; statements cannot (e.g., you cannot add one statement to another).
These are expressions:
These are statements:
x = 5;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|