Syntax - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
qja1608578437326.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities


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.