Using Stored Procedure stage to properly insert into DB2 MF

[UPS]

We are currently having difficulty in using the Stored Procedure Stage to properly insert into a DB2 Mainframe table. We have a decimal 15,2 field passing to Mainframe Stored Proc PIC S9(13)V9(2) USAGE COMP-3. All of the values get inserted except before the decimal place, this gets inserted as .00 always.

[vijayrc]

We are currently having difficulty in using the Stored Procedure Stage to properly insert into a DB2 Mainframe table. We have a decimal 15,2 field passing to Mainframe Stored Proc PIC S9(13)V9(2) USAGE COMP-3. All of the values get inserted except before the decimal place, this gets inserted as .00 always.

Try DOUBLE instead of decimal and this might work