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.
| 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 | 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. |
| 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:
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.