Oct 16

Teradata Utilities – FASTLOAD part 4

By admin in TD Utilities

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 –

Fastload Part 1

Fastload Part 2

Fastload Part 3

errlimit in fastload, fastload, fastload commands, fastload error tables, fastload limit, fastload login, fastload restart, how to write a fastload, session in fastload, sleep in fastload, tenacity and sleep, tenacity in fastload, teradata fastload, teradata utilities

admin

19 comments

1 ping

Skip to comment form

- umamahesh on July 13, 2018 at 6:31 am
- #
i have doubt in some of the tutorials they provide logon ip address but u didnot provide those things in starting is it possible to work
- Srini on December 16, 2016 at 12:48 am
- #
How can we read data in fastload error1 table, it’s in ASCII code, please let me know how we can make it as readable format.
1. - Srini on December 16, 2016 at 12:50 am
  - #
  Also please let me know whether we can see which record giving error while using ERRLIMIT
- Raj Kumar on May 26, 2016 at 3:05 am
- #
If I give ERRLIMIT as 10, does that mean the job can success even if there are 10 errors in ET table and 10 errors in UV table or it can handle only 10 errors from both the error tables?

Also, can you please post the working of Multiload
- Aylwin Cherian on May 11, 2016 at 7:18 am
- #
Hi Admin

I have a question related to Fast Load to old tables and new. So is there any difference or performance changes while a Fast Load loads data to old and new Tables.Please share your thoughts…N.B. im new to Teradata .. this question was asked by my senior but cant exactly get the actual answer…Please advice
1. - admin on May 21, 2016 at 10:40 pm
    Author
  - #
  please elaborate more on old and new tables ?
  Fastload is used to load data from data files to Teradata table. For table to table load you can use BTEQ scripts.
- Zohaib Hossain on March 10, 2016 at 7:38 pm
- #
Good explanation!
- Ganesh on January 1, 2015 at 10:12 am
- #
Hi ,

Thanks a lot…it is helpful.
- Wagner on October 3, 2014 at 5:17 pm
- #
Thanks, very helpfull!!!!
- Sathish on September 18, 2014 at 5:22 am
- #
Very simple, easily understandable and clear explanation. Keep up this work. Thanks a lot 🙂
- surendhar on June 16, 2014 at 7:19 pm
- #
really its very use fulll
- Prashant Nile on April 29, 2014 at 5:51 am
- #
HI
I ran the fastload script with errlimit 1 and inserted the records with same primary index for two record. It ran successfully with ET2=2 records even though the errlimit 1. why?
1. - srinivas on August 14, 2014 at 1:06 pm
  - #
  ET2 is working on phase 2, so error limit is not working here.
- Sumit on September 2, 2013 at 1:11 pm
- #
Hi, Jst want to know when fastload doen’t allow duplicate rows to be inserted then how does it checks for duplicacy. Because it is a very costly operation on DB but still fastload is considered as the fastest utility.
- Charankumar on April 29, 2013 at 1:29 pm
- #
Hi Admin,

we will appreciate if you could post some sample scripts and how that scripts will work.

Thanks.
- SSS on February 21, 2013 at 6:12 am
- #
Hi, Can you please post articles on other Teradata Loader utilities? I would be glad.

Good work!

Thanks,
1. - Charankumar on April 29, 2013 at 1:02 pm
  - #
  Hi Admin,
  
  Great work!!. even iam looking for other Teradata Loader utilities-Mload,TPT.
  
  Thanks,
- priya on October 18, 2012 at 3:54 am
- #
Nitin,… Really fantastic work by you… !! very informative at the same time.. very simple.
1. - admin on October 19, 2012 at 1:25 pm
    Author
  - #
  thanks … 🙂