Teradata MultiLoad Command Conventions
The following describes the command conventions to observe in Teradata MultiLoad job scripts.
Conditional expressions return a value of:
With the following exceptions, Teradata MultiLoad handles conditional expressions as described in the Teradata SQL reference documentation:
Do not use words that are logical operators as keywords, such as:
Record Mode Load Anomaly
When loading data in Record Mode into a NULLABLE DATE field, if the source data is a binary integer of value zero, then Teradata Database sets the field to NULL, not to zero.
Commands that are supported by Teradata MultiLoad do not use reserved words, except:
Though there is no specific restriction against doing so, avoid using the following as variable names:
Table Column Names
The column names of the table specified by Teradata MultiLoad TABLE command must be standard Teradata SQL column names that are not enclosed in quotation marks.
Invalid column names produce errors: