Syntax - 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


where the following is true:

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.
CONTINUEIF condition
Conditional phrase in which condition is of the form:
   position = value
where the following is true:
  • 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
  • value is the continuation indicator specified as a character constant or a string constant. FastExport 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 conditional phrase is true, then FastExport forms a single record 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 conditional phrase is false, then FastExport uses the current input record either by itself or as the last of a sequence of concatenated records.
Regardless of whether the condition evaluates to true or false, FastExport removes the tested string (the continuation indicator field) from each record.
INDICATORS
Condition that the input records defined by this LAYOUT command are in indicator mode
That is, the first n bytes of each record are indicator bytes, where n is the rounded up integer quotient of the number of fields defined by the LAYOUT command, divided by 8.
If this option is specified, the following FIELD commands must accurately define each field of the input record. The number of the defined fields and fillers is used to calculate the number of bytes of indicator data that are in each input record.