Archives of the TeradataForum

Message Posted: Thu, 23 Oct 2003 @ 16:16:23 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Single Fastload with Multiple Files of Different Layouts?

From:		Thomas F. Stanek

Is it possible to load a single table with multiple files having different layouts within a single Fastload step. I know that I can load a single file, pause the Fastload, then run another Fastload step with the new layout of the second file and continue loading, etc.

I'm curious if I could do this in a single step because of the CLEAR statement within Fastload, which "...cancels the definitions that were specified by a previous DEFINE command, including the input data source.". I am inferring from that statement that I can follow the CLEAR statement with a subsequent DEFINE statement and then load the table. I tried the following approach:

Begin Loading TableA....

DEFINE ...File= File1;

Insert TableA....

CLEAR;
DEFINE ....File= File2;

Insert TableA....

LOGOFF;

Unfortunately, while the CLEAR statement works in my script and so does the subsequent DEFINE, the second INSERT fails with the following error:

2660: Illegal INSERT detected after the END LOADING statement.

The data from File1 loaded, and the Fastload Paused.

This is more out of curiosity than desperate need.

We are running V2R4.1 with Fastload Version 7.05.

Thanks in advance!