Is there a way when creating table with sql I can force decimal values to signed rather than packed?
thanks for the help
jamie
PHP Code:
c/Exec Sql
c+ declare global temporary table workfile
c+ (OrdCreated char(01) ,
c+ Quote dec(7,0) ,
c+ QuoteSeq dec(3,0) ,
c+ QuoteDate dec(8,0) ,
c+ OrderType char(01) ,
c+ ActOrder dec(7,0) ,
c+ ActOrdSeq dec(3,0) ,
c+ BillOrder dec(7,0) ,
------------ 33 data records excluded -----
c+ with replace
c/End-Exec
thanks for the help
jamie
Comment