Example: TABLE|Stand Alone utility - Usage Notes - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the TABLE command.

TABLE Usage Notes 
Topic Usage Notes
Column Names in the Referenced Table The column names of the specified table must be Teradata SQL column names that need not be enclosed in quotation marks.

Tables cannot be created with invalid column names, and any nonstandard column name produces an error condition, depending on the nature of the divergence from the standard. The errors are:

  • Embedded blanks cause a syntax error, depending on the non-blank contents of the name.
  • Invalid characters cause an invalid name error.
  • Reserved words cause a syntax error that mentions invalid use of the reserved word.

Avoid using the .TABLE command if the FIELD names contain multi-byte characters. Instead, use FIELD commands, enclosing multi-byte field names in double-quotes. For example:

.FIELD “


”         *     INTEGER;
Intermixing TABLE Commands with FIELD or FILLER commands One or more TABLE commands with the FIELD or FILLER following a LAYOUT command can be intermixed.

This method of specifying record layout fields assumes each field, as defined by the data description of the corresponding column of tableref, is contiguous with the previous one, beginning at the next-available character position beyond any previous field specifications for the input records. The fields must appear in the order defined for the columns of the table.

The object identified by the tableref parameter must be a table. It need not appear as a parameter of the BEGIN MLOAD or BEGIN DELETE MLOAD command, but must either be the owner of the object or have at least one privilege on it.

If specified as an unqualified table name, the current default database qualifies it.

TABLE command and UDT type When the TABLE command is used and the table contains a structured UDT type, Teradata MultiLoad returns an external representation of the UDT and that requires the user to transform. The term “external type” means the data type of the external opaque container for a structured UDT and is the type returned by the from-sql transform method.