Teradata FastLoad Command Summary - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata FastLoad Command Summary

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.
  • Table 4 and Table 5 summarize the Teradata FastLoad commands that perform these activities. For a detailed description of each Teradata FastLoad command, see Chapter 3: “Teradata FastLoad Commands.”

     

    Table 4: 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

     

    Table 5: Teradata FastLoad Commands for Data Handling 

    Teradata FastLoad Command

    Function

    AXSMOD

    Specifies the name and initialization string for a shared object file that loads data from a file on networkattached 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
  • Variablelength text
  • Note: The SET RECORD command applies only to networkattached systems.

    SET SESSION CHARSET

    Specifies which character set is in effect during a specific Teradata FastLoad invocation

    Note: The SET SESSION CHARSET command applies only to networkattached systems.

    Note: The SET RETRY command is obsolete and ignored by Teradata FastLoad. For a description of the tenacity function, see “Invoking Teradata FastLoad” on page 33 and “TENACITY” on page 167.