Using Stored Procedure stage to properly insert into DB2 MF
Moderators: chulett, rschirm, roy
Using Stored Procedure stage to properly insert into DB2 MF
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.
Re: Using Stored Procedure stage to properly insert into DB2
Try DOUBLE instead of decimal and this might workUPS wrote: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.
![Laughing :lol:](./images/smilies/icon_lol.gif)