Syntax - MultiLoad

Teradata® MultiLoad Reference - 20.00

Release Number
October 2023
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

where the following is true:

CONTINUEIF condition
Conditional phrase in which condition is of the form:
position = value
  • position is an unsigned integer (never an asterisk) that specifies the starting character position of the field of every input record that contains the continuation indicator. The position is relative to the first character position of the input record or input record fragment, which is always position 1.
  • value is the continuation indicator specified as a character constant or a string constant. Teradata MultiLoad uses the length of the constant as the length of the continuation indicator field.
The condition specified as position = value is case sensitive. Always specify the correct character case for this parameter.
If the condition phrase is true, then Teradata MultiLoad forms a single record to be sent to the database by concatenating the next input record at the end of the current record. (The current record is the one most recently obtained from the external data source.)
If the condition is false, then Teradata MultiLoad sends the current input record to the database either by itself or as the last of a sequence of concatenated records. Regardless of whether the condition evaluates to true or false, Teradata MultiLoad removes the tested string (the continuation indicator field) from each record. All CONTINUEIF processing necessary to construct a complete record is done before any other processing of the record.
When the character set of the job script is different from the client character set used for the job, Teradata MultiLoad translates the specified value, which is either a character constant or a string constant, from the script character encoding to the client character encoding before evaluating the condition. Teradata MultiLoad uses the length of the constant in the client character encoding as the length of the continuation indicator field.
For example, the job script must be in Teradata EBCDIC when using the UTF-8client character set on z/OS; the job script can be in UTF-8 when using the UTF-16 client character set on workstation-attached systems.
Before using the UTF-8 client character set on a mainframe platform, check the character set definition to determine the code points and the Teradata EBCDIC and Unicode character mapping. Different versions of EBCDIC do not always agree as to the placement of any special characters which might be required in the job script. See International Character Set Support, B035-1125 for details.
Condition that the data is in the indicator mode
When the INDICATORS specification is used, Teradata MultiLoad sends all of the FIELD commands, including redefines, to the database.
Inappropriate INDICATORS specifications can corrupt the target table on the database. If INDICATORS is specified in the LAYOUT command and the data file does not contain indicator bytes in each record, the target table is loaded with spurious data.

Conversely, if INDICATORS is not specified and the data file contains indicator bytes in each record, the target table also is corrupted.

Always make sure that INDICATORS specifications match the mode of the data being sent to the database.

  • INDICATORS processing is done only after any CONTINUEIF processing is completed for a record.
  • If IS NULL or IS NOT NULL is specified in the APPLY clause, INDICATORS specification is required for all the data formats except VARTEXT format.
Name assigned to the layout for reference by one or more subsequent IMPORT commands
A layoutname must obey the same construction rules as Teradata SQL column names.