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. |