FastLoad for multiple input files

Database

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.

1 REPLY

Re: FastLoad for multiple input files

It is just the way it works.You can put the script one by one.

You can use tpt to load multiple files.

Cheers,