LAYOUT - FastExport

Teradata FastExport Reference

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

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.



Syntax Element



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


  • 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.
  • 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.


    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.


    Table 38: LAYOUT Command Usage Notes 


    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:

  • Each task is delimited by BEGIN EXPORT and END EXPORT commands
  • The LAYOUT command appears before any IMPORT command that references it