Fastload Commands
Given below is the list of Fastload commands which is extensively used in creation of Fastload scripts.
| ERRLIMIT | Specifies the maximum number of rejected ROWS allowed in error table 1 (Phase I). |
| LOGON/LOGOFF or, QUIT | LOGON begins a session. LOGOFF ends a session. QUIT is the same as LOGOFF. |
| NOTIFY | NOTIFY command used to inform the job that follows that some event has occurred. It is often used for detailed reporting on the Fastload job’s success. |
| RECORD | Specifies the beginning record number (or with THRU, the ending record number) of the Input data source, to be read by Fastload. Syntactically, This command is placed before the INSERT keyword. |
| SET RECORD | Used only in the LAN environment, this command states in what format the data from the Input file is coming: Fastload, Unformatted, Binary, Text, or Variable Text. The default is the Teradata RDBMS standard, Fastload. |
| SESSIONS | This command specifies the number of FastLoad sessions to establish with Teradata. It is written in the script just before the logon. The default is 1 session per available AMP. |
| TENACITY | Suppose Fastload is not able to obtain all the session required by it. In that case only two options are left. Either terminates the Fastload or re try to obtain all the sessions.TENACITY specifies the amount of time, in hours; Fastload will re try to obtain the sessions. The default for Fastload is “no tenacity”, meaning that it will not retry at all. |
| SLEEP | Working in conjunction with TENACITY, the SLEEP command specifies the amount of time in minutes to wait before retrying to obtain all sessions.For example, suppose if TENACITY were set at 5 and SLEEP at 10, then Fastload would attempt to logon every 10 minutes for up to 5 hours. If there were no success by that time, all efforts to logon would cease. |
To know more about Fastload check below mentioned links –
20 pings
Skip to comment form ↓
Teradata Utilities – FASTLOAD part 4 » TeraData Tech » BlinkMoth Software Industries | BlinkMoth Software Industries
October 16, 2012 at 11:27 pm (UTC 0) Link to this comment
[…] Post From Teradata – Google Blog Search: teradata fastload, fastload, teradata utilities, fastload error tables, fastload restart, […]