Either a CASE statement or an IF statement.
See Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148 for details.
You can specify these options for condition statements.
- CASE
- Keyword introducing the CASE conditional statement to qualify control statements.
- operand_2
- Value expressions or arithmetic and string expressions.
- THEN
- ELSE
- Keywords introducing the statements to be performed in the CASE statement.
- statement
- A valid SQL statement or SQL control statement.
- conditional_expression
- A boolean search condition used to evaluate whether a statement or statements embedded within an IF, CASE, REPEAT, or WHILE clause should be performed.
- END CASE
- Keywords marking the end of a CASE statement.
- IF
- Keyword introducing a conditional expression to qualify SQL control statements.
- ELSE
- ELSEIF
- A keyword introducing the THEN, ELSE, or ELSEIF clause in an IF statement.
- END IF
- Keywords marking the end of the IF statement.