Usage Notes

Teradata MultiLoad Reference

Teradata Tools and Utilities
Programming Reference

The following table describes the things to consider when using the IF, ELSE, and ENDIF commands.

IF, ELSE, and ENDIF Usage Notes 
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:

  • Zero is interpreted as false
  • Nonzero results are interpreted as true
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.