where the following is true:
-
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:
- Unsigned integer, which is the character position starting with 1
-
- Asterisk (*), which means the next available character position beyond the preceding field
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
Teradata Vantage™ - Database Utilities
, B035-1102
.
- This description is used to generate the data description for this field in the USING modifier for the SELECT statement.