Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2003 @ 17:46:28 GMT

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

Sorry for being unclear in my first mail. I already have a couple of walkarounds (CAST DEC is one of them).

I was wondering if someone else has suffered this error before and if NCR has an explanation on why and how it is produced (or a DR).

In fact, an explain (when d1 is dec(16,0) or less) shows that c1 is casted to float with a format literal. It seems that DEC(x.0) with x>16 makes the parser create a format literal that is rejected by the code creator later. An explain when x > 16 is not generated, which indicates that the error is produced before the explainer.

Thanks!

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