All Forums Database
gkatiyar 19 posts Joined 09/13
23 Jan 2014
FastLoad for multiple input files

Hi All, I was trying to load multiple files using Fastload.
I was able to load the files using multiple Fastload scripts (First Script, do not give the END LOADING. Last script, give END LOADING.)
Then i tried to merge all these scripts to make one script, which is like-
.LOGON....;
Table creation and drop etc;
DEFINE;
BEGIN LOADING.....;
INSERT.....;
.LOGOFF
.LOGON....;
/*Table creation and drop etc;*/
DEFINE;
BEGIN LOADING.....;
INSERT.....;
.LOGOFF
.LOGON....;
/*Table creation and drop etc;*/
DEFINE;
BEGIN LOADING.....;
INSERT.....;
END LOADING;
.LOGOFF
For this kind of script, Only the first LOGIN....LOGOFF got executed successfully and the Fastload job was put into pause state but it did not execute the second LOGIN onwards.
I have read that Its not possible to load multiple files using a single Fastload script but i am looking for a reason why this is not possible. Because in case of multiple scripts also, the job gets paused and completed after the last script (containg END LOADING).
Apprecite your help.

Regards, Gaurav Katiyar
Raja_KT 1246 posts Joined 07/09
23 Jan 2014

It is just the way it works.You can put the script one by one.
You can use tpt to load multiple files.
Cheers,
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.