Teradata FastLoad Command Summary | Teradata FastLoad - 17.10 - Teradata FastLoad Command Summary - 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)
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 supports Teradata Active System Management (TASM), the number of sessions to run the jobs is determined by the database setup rules. Therefore, the SESSIONS command has no effect. For more information, see Teradata Vantage™ - 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 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 workstation-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 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 workstation-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 workstation-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.