Usage Notes - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
16.20
Published
September 2020
Language
English (United States)
Last Update
2020-09-11
dita:mapPath
lki1527114222329.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2410
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 END IF Command 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 FastExport supports the nesting of IF commands to a level of 100.
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
Variables in the IF Expression The conditional expression can be either user-defined variables or predefined system variables.
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.