Archives of the TeradataForum
Message Posted: Wed, 24 Oct 2001 @ 13:38:48 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|