A sample Fastload script
Below is the sample Fastload script which is designed to work in WINDOWS OS. To run the Fastload in your system you need to install Fastload utility and then go to command prompt and type –
>fastload < c:\fload_1.txt
where c:\fload_1.txt is the name and path of the Fastload which you want to execute.
A sample Fastload script
/***** Section 1 *****/
/* In this section we give the LOGIN credentials which is required to connect to TD system. Sessions command is used to restrict the number of sessions Fastload will make to connect to TD. Default is one session per AMP. */
.SESSIONS 4;
.LOGON 127.0.0.1/tduser,tduser;
/***** Section 2 *****/
/* In this section we are defining the table which we want to load from Fastload. DROP commands are optional. There is no need to define the structure of ERROR tables they’ll be created itself by Fastload. */
drop table retail.emp_test;
drop table retail.emp_test_er1;
drop table retail.emp_test_er2;
create table retail.emp_test
(
emp_id integer not null,
emp_name varchar(50),
dept_id integer,
salary integer,
dob date format’yyyy-mm-dd’
)
unique primary index(emp_id);
/***** Section 3 *****/
/* In this section we give the BEGIN loading statement. As soon as Fastload receives this statement it starts PHASE 1. */
BEGIN LOADING
retail.emp_test
ERRORFILES
retail.emp_test_er1, retail.emp_test_er2;
/***** Section 4 *****/
/*RECORD command is used to skip the starting rows from the data file. RECORD THRU command is used to skip the last rows of data file. SET RECORD command is used to define the records layout and the “,” is the delimiter which we are using in our data file to separate columns. */
.RECORD 1;
.RECORD THRU 3;
SET RECORD VARTEXT “,”;
/***** Section 5 *****/
/* DEFINE statement is used to define the structure of the data file. This should be in accordance with the actual target table structure. Fastload DEFINE statement allows only VARCHAR format. */
DEFINE
emp_id (VARCHAR(9))
emp_name (VARCHAR(50))
dept_id (VARCHAR(9))
salary (VARCHAR(9))
dob (VARHAR(50))
/***** Section 6 *****/
/* FILE command defines the data file path and name. */
FILE = C:\fload_data.txt;
/***** Section 7 *****/
/* INSERT command is used to load the data file into actual target table. NOTE – For DATE columns we can use the data conversion by the syntax given below. */
INSERT INTO retail.emp_test
(
:emp_id ,
:emp_name,
:dept_id ,
:salary,
:dob (format ‘yyyy-mm-dd’)
);
/***** Section 8 *****/
/* END LOADING ends PHASE 1 and starts the execution of PHASE 2. LOGOFF is required to close all the sessions created by Fastload. */
END LOADING;
.LOGOFF;
This is the simplest Fastload script which can be used to understand the concepts of Fastload. Besides the commands given here there are also some other commands as well, which you can see in next post.
Based on the requirements we can always tweak the Fastload.
To know more about Fastload check below mentioned links –
105 comments
1 ping
Skip to comment form
Regards. Terrific information.
Truly tons of valuable tips!
Amazing plenty of helpful material!
Fantastic facts. Cheers!
Seriously loads of beneficial material.
Nicely put. Thanks a lot!
Nicely put, Appreciate it.
Amazing write ups Thanks.
You explained it really well.
Useful information, Appreciate it!
Cheers! I value this!
You’ve made the point.
Nicely put, Regards!
Good forum posts. Cheers!
Thank you, Quite a lot of tips!
Superb facts, Appreciate it!
You revealed that fantastically!
Regards, A good amount of material!
Regards. I value this!
Awesome forum posts, With thanks!
Many thanks, A good amount of write ups!
Really loads of awesome info!
Kudos, I enjoy this!
Thank you, I value this.
With thanks. Quite a lot of forum posts.
Thanks! Fantastic stuff.
Useful facts Regards!
You have made your stand quite well!!
Beneficial advice Regards.
Fantastic postings, Thanks.
You explained this really well!
Many thanks! Good information.
Kudos. An abundance of write ups!
Regards. An abundance of data!
Point certainly used!.
You suggested this terrifically!
Thanks, Quite a lot of information.
Fantastic information Thank you.
Cheers! Numerous data!
Nicely put, Thank you.
Information well used!.
Lovely content, With thanks.
Nicely put. Appreciate it.
Thanks, I like this!
Nicely put, Thank you.
Nicely put. Thank you.
Perfectly spoken genuinely. !
Nicely put, Many thanks.
Really all kinds of awesome data.
Good data, Thanks a lot.
You actually suggested it perfectly!
Nicely put, Appreciate it!
Cheers! A good amount of facts!
Helpful material Cheers.
Great content Thanks a lot.
You actually said this well!
Good tips Kudos!
This is nicely expressed. .
You’ve made your point.
You stated that really well!
Thank you! Plenty of write ups.
Thanks a lot. An abundance of posts.
Regards. Wonderful information!
Thank you! Ample postings.
Beneficial write ups Cheers.
Superb posts. Many thanks.
You’ve made the point.
Thanks! Quite a lot of forum posts!
Awesome material, Cheers.
With thanks. I appreciate this!
With thanks, A good amount of facts.
You definitely made the point!
Whoa loads of excellent knowledge.
Truly a good deal of amazing knowledge.
This is nicely said. !
With thanks, I enjoy this.
Nicely put, Cheers.
Point well applied..
Thanks a lot, A good amount of facts!
You made your position pretty well..
Thank you! Good stuff.
This is nicely expressed. !
Many thanks, I appreciate this.
Amazing material, Many thanks.
Wonderful data Regards!
Hello! This is kind of off topic but I need some guidance from an established
blog. Is it hard to set up your own blog? I’m not
very techincal but I can figure things out pretty quick.
I’m thinking about setting up my own but I’m not sure where to start.
Do you have any ideas or suggestions? Appreciate it
Have you ever thought about adding a little
bit more than just your articles? I mean, what you say is fundamental and all.
But think about if you added some great images or video clips
to give your posts more, “pop”! Your content is excellent but with
pics and video clips, this blog could certainly be one of the most beneficial in its niche.
Fantastic blog!
hey there and thank you for your info – I’ve certainly picked up something new from right here.
I did however expertise a few technical points using this web site,
as I experienced to reload the web site lots of times previous to
I could get it to load correctly. I had been wondering if your hosting is OK?
Not that I’m complaining, but sluggish loading instances times
will often affect your placement in google and can damage your high-quality score if ads
and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and can look out for much
more of your respective interesting content. Make sure you update
this again soon.
With havin so much content do you ever run into any issues of plagorism or copyright violation? My site has a lot of completely unique content I’ve either authored myself
or outsourced but it looks like a lot of it is popping it up all over the
web without my authorization. Do you know any ways to help protect against content from being ripped off?
I’d certainly appreciate it.
Amazing things here. I am very glad to see your article.
Thanks a lot and I’m having a look ahead to touch you.
Will you please drop me a mail?
Hi there, I enjoy reading through your post.
I like to write a little comment to support you.
Hi there colleagues, how is the whole thing, and what you want to say about this article, in my view its genuinely awesome designed for me.
There’s definately a lot to learn about this issue. I really
like all of the points you’ve made.
Yo, tai188bet looks promising. They’ve got a solid selection of games and the site’s not clunky like others I’ve tried. Worth a look if you’re into online betting. Check out tai188bet and let me know what you think!
Heads up, poker fans. Heard about 97pkrgame and checked out their site 97pkrgame.info. Seems like it might be fun. Give 97pkrgame a go!
Been playing on winph444 for a little while now. It’s alright, got a decent variety. Could be better, could be worse. Check it out and make your own judgement: winph444.
30t2fi
sd9nom
zta3bx
Hi Admin,
Thank you very much Fastload four parts are awesome
I have follow only those four parts my total doubts on fastload has been clarified.
Once again thank you for your lovely posts.keep it up admin.
Hi ,
Can any one send sample script to load multiple file to load single empty table using fast load.
please test the script first and send reply.
Hi Admin,
Why do we need to use RECORD and RECORD THRU , why do we need to skip the first and last rows of the data files by using these two commands.
Regards,
Priyabrat
Hi
since the first record will come along with column name, we will skip the first record
We use FASTLOAD in JCL with NOSPIE option, what does this do? Why is it needed?
Thanks!
Hi Shari,
NOSPIE parm in JCL used with FASTLOAD in order to write SYSDUMP messages in case of job failures. This parm was mandate till TD 13.0 version. TD 13.10 version on wards we do not need NOSPIE parm in our JCL.
[…] Post From Teradata – Google Blog Search: A sample Fastload script. Below is the sample Fastload script which is designed to work in […]