Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 13:58:06 GMT

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

Are you loading / querying via ODBC? The fixed precision numeric definition for ODBC only supports up to 15 decimal digits. You can use a CLI- based load / query tool (e.g. BTEQ) or you can use CHAR/VARCHAR fields externally and CAST them on the database side:

     INSERT INTO ... ( cast('10101010101010101.' as DECIMAL(18,0)),...)

     SELECT cast(Field1 as CHAR(20))...

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