Teradata FastLoad Command Summary - 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
The Teradata FastLoad commands perform two types of activities:
  • Session control – Session control commands begin and end Teradata FastLoad sessions and provide online information about a particular Teradata FastLoad operation.

    and

  • Data handling – Data handling commands establish and define a Teradata FastLoad operation.

The following two tables summarize the Teradata FastLoad commands that perform these activities. For a detailed description of each Teradata FastLoad command, see Teradata FastLoad Commands.

Teradata FastLoad Commands for Session Control 
Command Name Function
HELP Lists Teradata FastLoad commands and options
HELP TABLE Creates a list of field names which can be used with the INSERT statement
LOGOFF

QUIT

Ends Teradata FastLoad sessions and terminates Teradata FastLoad
LOGON Begins one or more Teradata FastLoad sessions
NOTIFY Specifies a user exit or action to be performed when certain significant events occur
OS Enters client operating system commands
SESSIONS Specifies the number of Teradata FastLoad sessions logged on with a LOGON command and, optionally, the minimum number of sessions required to run the job. If the database system (DBS) supports Teradata Active System Management (TASM), the number of sessions to run the jobs is determined by the DBS setup rules. Therefore, the SESSIONS command has no effect. For more information, see Database Administration (B035-1093).
SHOW Shows the current field/file definitions established by DEFINE commands
SHOW VERSIONS Shows the current level of all Teradata FastLoad software modules
SLEEP Specifies the number of minutes that Teradata FastLoad pauses before retrying a logon operation
TENACITY Specifies the number of hours that Teradata FastLoad continues trying to log on when the maximum number of load jobs is already running on the Teradata Database
Teradata FastLoad Commands for Data Handling 
Command Name Function
AXSMOD Specifies the name and initialization string for a shared object file that loads data from a file on network-attached client systems
BEGIN LOADING Identifies the tables used in the Teradata FastLoad operation and, optionally, specifies when checkpoints are taken or if the user supplies indicator data
CLEAR Cancels the current DEFINE command specifications
DATEFORM Specifies the form of the DATE data type specifications for the Teradata FastLoad job
DEFINE Describes each field of an input data source record and specifies the name of the input data source or INMOD routine
END LOADING Informs the Teradata Database that all input data has been sent
ERRLIMIT Limits the number of errors detected during the loading phase of a Teradata FastLoad job

Processing stops when the limit is reached.

RECORD Specifies the number of a record in an input data source at which Teradata FastLoad begins to read data and/or the number of the last record to be read
RUN Invokes the specified external source as the current source of commands and statements
SET RECORD Specifies that the input data records are either:
  • Formatted
  • Unformatted
  • Binary
  • Text
  • Variable-length text
The SET RECORD command applies only to network-attached systems.
SET SESSION CHARSET Specifies which character set is in effect during a specific Teradata FastLoad invocation
The SET SESSION CHARSET command applies only to network-attached systems.
The SET RETRY command is obsolete and ignored by Teradata FastLoad. For a description of the tenacity function, see Invoking Teradata FastLoad and TENACITY.