Archives of the TeradataForum

Message Posted: Tue, 26 Jan 2016 @ 07:53:03 GMT

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

<-- Anonymously Posted: Tuesday, January 26, 2016 03:43 -->

Dears,

The flush is a good prosition.

Regarding the usecount, it's is a bit funny, because for some database TD, actually does a count, but it seems not for all.

However, I'll try to dynamically generate a " BEGIN QUERY LOGGING WITH USECOUNT ON ;" statement per database and execute the results immediately after. (e.g. by using BTEQ).

That should do the trick right? Or does it have to be only 1 statement containing all the databases after the .... ON, separated by a comma?

Regards

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