Usage Notes - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.