INSERT | Example 3 | Teradata FastLoad - 17.00 - Example 3: INSERT - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.ditaval

Sometimes the records in an input data source contain data that does not belong in the Teradata FastLoad table. If, for example, each record contains 100 bytes of extra data, a dummy field can be defined in the DEFINE command that is not referenced in the INSERT statement.

The following command example constructs a list of field names that match the current definition of NewTable appended to the definition of the extra data item:

DEFINE ExtraData (CHAR (100)) FILE = InFile;
INSERT NewTable.*;

When extra data is used in the input data source with the INSERT TABLE .* feature, the extra data must be located at the beginning of each record.

This feature cannot be used if the extra data occurs in the middle or at the end of the records. In this case, explicitly define each data item in the data source and each item in the values clause of the INSERT statement.