Decimal place converted to zero

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
danddmrs
Premium Member
Premium Member
Posts: 86
Joined: Fri Apr 20, 2007 12:55 pm

Decimal place converted to zero

Post by danddmrs »

Job inserting/updating data in a Datacom table on the mainframe is converting all decimal places to .00.
Source = 40321.21
Output to database is getting 40321.00

ODBC1(Prod) --> Transformer --> ODBC2(Test)

In DataStage both the Source and Target are defined as Decimal with Length 15 Scale 2. Both are Datacom tables on the mainframe and the Pic of the mainframe fields is PICTURE S9(13)V9(2) Comp-3. It is reading from the source correctly and writing everything up to the decimal place correctly.

I did verify the data out of the transformer is correct by writing to sequential file.
Also tried Arnd's IntToComp3 Routine but data was rejected in the SQL because of non-numeric.

Thanks in advance!
Richard
Post Reply