Archives of the TeradataForum
Message Posted: Fri, 19 Oct 2001 @ 14:52:38 GMT
| Subj: || || Re: Case statements |
| From: || || Geoffrey Rommel |
| ||We regularly use CASE statements in our code as they are excellent in that only one pass of a table is required to satisfy a
This is a small point, but everyone should be aware that these are CASE expressions, not statements. 'x' is an expression; 'y = x +
5' is a statement. Similarly, SELECT is a statement; CASE ... END is an expression within the statement.
I mention this because V2R4.1 will have a CASE statement (only within stored procedures, I think), so it may become important to keep
this distinction in mind.