Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 May 2012 @ 13:55:53 GMT


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


Subj:   Re: Using ErrorCode and ActivityCount within Bteq
 
From:   Dave Wellman

Hi David,

You're correct, they can only be used in the script.

However, if you use Query Logging then the ActivityCount and Errorcode are recorded within the dbms. You can use QueryBands from within your script to match up to specific DBQL rows. You would have to wait for the DBQL rows to be written to disk before you can get the information and write to your own tables.

Would that give you what you want?


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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