The LAYOUT command, used with an immediately following sequence of FIELD and FILLER commands, specifies the layout of the file that provides data values for the USING modifier of the SELECT statement.
where:
|
Syntax Element |
Description |
|
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: Note: 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. Note: 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. |
Table 38 describes the things to consider when using the LAYOUT command.
|
Topic |
Usage Notes |
|
Command Frequency and Placement |
A LAYOUT command specification must be referenced by each IMPORT command in the FastExport job script. In all cases, the LAYOUT command must be presented before an IMPORT command that references it. Each LAYOUT command must be immediately followed by a series of FIELD and FILLER commands that define the composition of a logical record. |
|
Using the same LAYOUT command in Multiple FastExport Tasks |
The same layoutname specification can be referenced in more than one FastExport task, provided that: |