Usage Notes - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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.