Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   BTEQ script statistics
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023