Page 1 of 1
Using Stored Procedure stage to properly insert into DB2 MF
Posted: Mon Apr 30, 2007 2:11 pm
by 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.
Re: Using Stored Procedure stage to properly insert into DB2
Posted: Mon Apr 30, 2007 3:12 pm
by vijayrc
UPS 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.
Try DOUBLE instead of decimal and this might work
![Laughing :lol:](./images/smilies/icon_lol.gif)