Re: JDBC CallableStatement, plain Program Call, and output parameters...

On 01/09/2008, at 7:27 PM, Thorbjørn Ravn Andersen wrote:

As mentioned I need to get the PIC(5) mask to work properly. If I
cannot get rid of the sign, I can live with only being able to stuff a
sign + four digits in the area if I can get the result properly back
from C and D :)

I'd still appreciate any hints or suggestions :)

Your COBOL program is fine. The SQL statement looks fine to me. Given that all the numbers are stuffed in the COOL program and they are all passed in from whatever invokes the stored procedure I would be examining the data being passed up from the Java application.

A 009120 ZONED(5,0) **INVALID DATA '4EF0F0F0F0'X
B 009126 ZONED(5,0) **INVALID DATA '4EF0F0F0F2'X
C 00912C ZONED(5,0) **INVALID DATA '4EF0F0F0F0'X
D 009132 ZONED(5,0) **INVALID DATA '4EF0F0F0F0'X

The hexadecimal for these values ought to be:
X'F0F0F0F0F0'
X'F0F0F0F0F2'
X'F0F0F0F0F0'
X'F0F0F0F0F0'

So look at why the Java application is not passing properly formatted NUMERIC data.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------