Archives of the TeradataForum

Message Posted: Thu, 09 Aug 2001 @ 15:04:13 GMT

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

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.

SEL  *
FROM DBC.TABLES
WHERE     DATABASENAME='DATABASENAME'
WHERE     LASTALTERNAME='MLOADID'
;

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.

SEL  *
FROM DBC.ACCESSLOG
WHERE     DATABASENAME='DBNAME'
AND  TVMNAME='LOGTABLENAME'
;

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