Archives of the TeradataForum
Message Posted: Thu, 09 Aug 2001 @ 15:04:13 GMT
| Subj: || || Re: Fastload vs Multiload |
| From: || || Jim Downey |
The following seems to work at our site because we have userids that only do multi-loads. The last alter name then contains the last id
to alter the table. It looks to me that inserting rows meets this condition. Assuming no other activity has taken place, this would
identify which tables had been multi loaded by the multi load id.
If that doesn't work, the following will identify when the multi load log file had rows inserted and then was dropped. The logfile name
is the one listed in the .LOG statement in the multi load script. We use a naming convention that just appends _log to the end of the table
name that is being multiloaded.