Teradata FastLoad Command Summary
The Teradata FastLoad commands perform two types of activities:
and
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.”
Command Name |
Function |
Lists Teradata FastLoad commands and options |
|
Creates a list of field names which can be used with the INSERT statement |
|
Ends Teradata FastLoad sessions and terminates Teradata FastLoad |
|
Begins one or more Teradata FastLoad sessions |
|
Specifies a user exit or action to be performed when certain significant events occur |
|
Enters client operating system commands |
|
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). |
|
Shows the current field/file definitions established by DEFINE commands |
|
Shows the current level of all Teradata FastLoad software modules |
|
Specifies the number of minutes that Teradata FastLoad pauses before retrying a logon operation |
|
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 Command |
Function |
Specifies the name and initialization string for a shared object file that loads data from a file on network‑attached client systems |
|
Identifies the tables used in the Teradata FastLoad operation and, optionally, specifies when checkpoints are taken or if the user supplies indicator data |
|
Cancels the current DEFINE command specifications |
|
Specifies the form of the DATE data type specifications for the Teradata FastLoad job |
|
Describes each field of an input data source record and specifies the name of the input data source or INMOD routine |
|
Informs the Teradata Database that all input data has been sent |
|
Limits the number of errors detected during the loading phase of a Teradata FastLoad job Processing stops when the limit is reached. |
|
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 |
|
Invokes the specified external source as the current source of commands and statements |
|
Specifies that the input data records are either: Note: The SET RECORD command applies only to network‑attached systems. |
|
Specifies which character set is in effect during a specific Teradata FastLoad invocation Note: The SET SESSION CHARSET command applies only to network‑attached 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.