The following table describes the things to consider when using the IF, ELSE, and ENDIF commands.
Topic | Usage Notes |
---|---|
ELSE Clause | Use the optional ELSE clause to execute commands when the condition is evaluated as false. |
Nesting IF Commands | Teradata MultiLoad supports up to 100 nested IF commands. |
Numeric Results of the Conditional Expression | The conditional expression is an expression that can be evaluated as either true or false. When evaluation of the expression returns a numeric result:
|
Variable Substitutions | Any ELSE or ENDIF commands must be present in their entirety, and cannot be composed simply of variables in need of substitution. |
Commands and statements following an IF, ELSE, or ENDIF structure that are not executed are not parsed and do not have their variables substituted. | |
Variables in the IF Expression | The conditional expression can be either user-defined variables or predefined system variables. |