The following table describes the things to consider when using the IF, ELSE, and ENDIF commands.
|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.|