Archives of the TeradataForum
Message Posted: Wed, 08 Aug 2001 @ 19:27:27 GMT
There are multiload variables which indicate how many rows are inserted, deleted, etc for a mload process
&sysinscnt - number of inserts
there is a variable indicating the state of the last operation (&sysrc) and other variables built in.
I believe that the documentation has ALL the variables that can be used. Our system places these values in a table at the end of a run and this information can be examined later if you do this. We called ours AuditTable and it was done OUTSIDE the last END MLOAD. [Note: Multiload cannot do SELECTS but it can do .IF statements dependent on this information].
An example of a statement to collect information is below:
Insert into AuditTable Values ('DatabaseName' ,'TableName' ,'MLOADProcessName' ,'&sysdate4' ,cast('&systime' as time(0)) ,date ,current_time ,&sysinscnt ,&sysupdcnt ,&sysdelcnt ,&sysuvcnt ,&sysetcnt ,&sysrc ,'&OSUser' );
I hope I understood your question correctly.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|