where the following is true:
-
fieldname
- Name of a field in a record of the input data source, from left to right.
- You cannot use FILE, DDNAME, or INMOD for a fieldname.
Some or all of the field names can be omitted if the accompanying INSERT statement uses the “wild card” table name specification (
tname.*) for all of the columns in the table. For the syntax of the
tname.* specification, see the
INSERT statement description.
-
datatype
- Keyword or keyword phrase that specifies the data type of the field.
- For details on data types and data conversions, see
Teradata Vantage™ - Data Types and Literals, B035-1143.
- The valid data types for records in a Teradata FastLoad table are as follows:
- BIGINT
- BYTE (n)
- BYTEINT
- CHARACTERS (n)
- DATE
- DECIMAL (x) or DECIMAL (x,y)
- FLOAT
- GRAPHIC (n)
- INTEGER
- LONG VARCHAR
- LONG VARGRAPHIC
- NUMBER (p)
- NUMBER
- NUMBER(p,s)
- NUMBER(*,s)
- PERIOD(DATE)
- PERIOD(TIME[(n)])
- PERIOD(TIME[(n)] WITH TIME ZONE)
- PERIOD(TIMESTAMP[(n)])
- PERIOD(TIMESTAMP[(n)] WITH TIME ZONE)
- SMALLINT
- VARBYTE (n)
- VARCHAR (n)
- VARGRAPHIC (n)
- NULLIF=value
- Keyword phrase that loads the database field with a null value if the defined client field contains the specified value.
- The value specification can be 1 to 80 bytes in length, and it pertains only to BYTE, CHAR and GRAPHIC types. It does not pertain to integer and float data types.
- The NULLIF option occurs only with the DEFINE command.
- FILE=filename
- Keyword phrase specifying the name of the data source that contains the input data.
-
fileid must refer to a regular file. Specifically, pipes are not supported.
- For mainframe-attached systems, replace FILE with DDNAME for z/OS. DDNAME is the sequential data set for z/OS.
- In UNIX and Windows, the fileid FastLoad supports file name of size of up to 1024.The filename can contain the following characters: parenthesis, comma, or equal sign.
- INMOD=name
- Keyword phrase specifying the name of a user exit routine that provides input data records.
- For more information about using INMOD routines, see INMOD and Notify Exit Routines.
- If INMOD module output messages to stdout, the character set that INMOD uses is independent of the character set that Teradata FastLoad uses; the display on stdout can be of mixed character sets. For example, IMMOD can output messages in ASCII and Teradata FastLoad can output messages in UTF-16.
- In UNIX and Windows, FastLoad supports the INMOD name of size of up to 1024. The INMOD name can contain the following characters: parentheses, comma, or equal sign.