Archives of the TeradataForum

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

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

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>>