Archives of the TeradataForum

Message Posted: Fri, 18 Oct 2003 @ 01:44:57 GMT

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

I've loaded signed decimal (overpunch numeric before), the key is to use the appropriate format string with 's'. So..

select '2919A' (dec(7,2), format '999v9s'); = 2919.10
select '1256{' (dec(12,0), format '99999s'); = 12560

in mload, in the Layout define them a char() on input in insert statement cast the :var with above casting.

insert tbl values ( :var (dec(7,2), format '999v9s'));

--
Dwight Etheridge
Teradata Certified Master

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