DEFINE | Syntax | Teradata FastLoad - 17.10 - Syntax - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

DEFINE command syntax diagram

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.