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

Teradata® FastLoad Reference

Release Number
June 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)

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.