Archives of the TeradataForum

Message Posted: Wed, 29 Aug 2001 @ 17:10:49 GMT

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

<-- Anonymously Posted: Wednesday, August 29, 2001 11:52 ->

Hello All

We are running Teradata V2R4 and I am trying to determine how many rows were updated versus inserted in BTEQ. I only see an "ACTIVITYCOUNT" system variable in BTEQ (unlike Multiload which keeps the count of the #inserts, updates, deletes, etc in system variables). Are there variables which I have not found which can be used in BTEQ that automatically (rather than programmatically) keep track of this information?

The ACTIVITYCOUNT variable would be ok if you were only doing 1 activity. However, we do a combined insert/update operation (so that rollbacks occur on both operations) and I am thinking that since ACTIVITYCOUNT only returns the TOTAL Count of operations that I cannot distinguish between the two.

UPDATE Table1 WHERE ;INSERT INTO Table1 WHERE ;

The statement fragment (sample) will upsert into Table1 based on the "conditions". When this statement completes, the program displays the number of rows inserted as well as updated.

Thanks in advance for your advice.

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