Syntax - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
fel1608578437279.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities


where the following is true:

CONTINUEIF condition
Conditional phrase in which condition is of the form:
position = value
where
  • 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 Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125 for details.
INDICATORS
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.
layoutname
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.