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.