Syntax - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities


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 later in this chapter.
datatype
Keyword or keyword phrase that specifies the data type of the field.
For details on data types and data conversions, see SQL 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 Teradata 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.