Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 13:38:48 GMT

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

I have used this scenerio.

Create Table - define column as Decimal(x) ( no second parameter)
Define         Define the incoming field as Char(x)
Insert         Use Format on the insert  '9(x)s'.

I take no credit - straight from Brian Marshalls book on how to handle conversions for signed fields. page 95 application and archive recovery utilities.

Works for me every time in the MVS environment.

Catherine Thompson-Britt

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