Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Fastload vs Multiload
From:   John Hall

Just to re-state your question: Is there any way to tell, just using information contained on the Teradata, whether the last load/update/delete of any table was performed by MLoad?

The answer is 'No', there's nothing in the data dictionary which indicates how a table was last loaded or modified (whether SQL, MLoad or FDL). Nor is there any characteristic about the table itself which would give an indication.

Just in case I mis-understood your question: The flip-side is that if submitted from MVS/VM, you can look in DBC.EVENTLOG (column LOGONSOURCE) to identify jobs which contain MLoad or FDL steps - but you have to go back to the job source to actually determine which tables were affected.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023