Archives of the TeradataForum

Message Posted: Tue, 27 May 2008 @ 22:19:30 GMT


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

Subj:		Re: Dieter's collect stats query on v12

From:		Dieter Noeth

Anomy.Anom wrote:

I also tried to duplicate the 4 as padbytes logic in each branch of the query and ran into numeric overflow.

Should PadBytes be cast as an integer? As a Bigint? Dec(18,0) ?

Are there some intermediate calcs that need to be cast?

Those numeric overflow shouldn't occur if the PadBytes are modified correctly. I thought i fixed that, it was due to some unusual default formats.

I remember a 3610 on a 32-bit TD12 beta once, but it seemed to be fixed. The strange thing about it was: It only happened when submitted using ODBC, but not with BTEQ. And it was only for the view version, not the base table version, the only difference between both is an additional calculation in the base table version (but only the view version crashed).

Please try both versions and use SQL Assistant and BTEQ.

But still open an incident, because a 3610 is always a bug.

Dieter