×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 / \
--------------------------------------------------------------------
midrange.com
