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?



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: 28 Jun 2020