Archives of the TeradataForum
Message Posted: Thu, 17 May 2012 @ 13:55:53 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|