Archives of the TeradataForum
Message Posted: Wed, 29 Aug 2001 @ 17:10:49 GMT
<-- Anonymously Posted: Wednesday, August 29, 2001 11:52 ->
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|