Archives of the TeradataForum

Message Posted: Sat, 22 Apr 2006 @ 14:03:00 GMT

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

Boris,

You have to define the field as DECIMAL(13,2) for COBOL equivalent PIC S9(11)V99 COMP-3 and while loading cast it like CAST(:FIELD_NAME AS DECIMAL(13,2) FORMAT '99999999999V99S' )

Thanks,

Saravana Kumar

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