Archives of the TeradataForum

Message Posted: Thu, 14 Feb 2008 @ 23:55:10 GMT

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

Hi,

I just tried your code with "I" as being the comparison value and it works fine for me.

I had to get rid of the "And current_perm / (2**30) > 1" as that's far to big for my little test demo database and I would have expected it to be too large for your system too.

Are you sure you are capturing DBQL correctly and there are 'I' rows in the DBQL obj table?

Cheers

John Street

Senior Solution Architect
Teradata Certified Master

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