Archives of the TeradataForum
Message Posted: Thu, 23 Oct 2003 @ 16:16:23 GMT
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;
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!
Thomas F. Stanek TFS Consulting, Inc.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|