The FILLER command specifies a field that is not sent to Teradata Database as part of the input record that provides data values for the constraint parameters of the SELECT statement.
where:
|
Syntax Element |
Description |
|
fieldname |
Optional name for the input record field The fieldname specification is required only if the field is referred to by the nullexpr condition of a FIELD command. |
|
startpos |
Starting position of the specified field in an input data record startpos can be specified as an: Note: When using the CONTINUEIF condition of the LAYOUT command to continue input records, a startpos specified by an integer value refers to a character position in the final concatenated record from which the continuation indicator has been removed. |
|
datadesc |
Type and length of data in the field The datadesc specification can be any of the data type phrases shown in Utilities (B035‑1102). This description is used to generate the data description for this field in the USING modifier for the SELECT statement. |
Table 35 describes the things to consider when using the FILLER command.
|
Topic |
Usage Notes |
|
Command Placement and Frequency |
A FILLER command must be preceded by a LAYOUT command. One or more FILLER commands, or a combination of FILLER commands and FIELD commands, define the composition of the input data record to supply values for the USING modifier of the SELECT statement. |