Archives of the TeradataForum

Message Posted: Wed, 28 Nov 2001 @ 18:47:01 GMT

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

You are probably using Queryman ... �no? Queryman uses ODBC, which stores numbers as "double" (FLOAT), which has less precision than decimal(18). Hence your last few digits appear to be wrong.

If you use BTEQ, the numbers should appear correctly. If you must use Queryman, you will have to cast the numbers twice like so:

select cast(cast( bignumber as format 'zzz,zzz,zzz,zzz,zzz,zz9') as char(24)) ...

--wgr=

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