Using Stored Procedures on AS/400 from servlet

Hi,

We are attempting to use SQL within a stored procedure on an AS/400.  We
are using VAJ 3.5 test environment using servlets and jsp's.  The servlet
has a callable statement to the stored procedure passing three input parms.
I made the stored procedure a RPG ILE program.  It displays the input parms
using the output specifications in the RPG program.  I can see the parms
are being passed correctly from the report produced by the program.
However, the SQL which defines a cursor and does fetches does not find any
rows meeting the criteria of the parms passed to it.  If I execute the
stored procedure from the command line on the AS/400, passing the identical
parms, there are rows found.  The servlet is using the AS/400 toolbox for
Java.

Has anyone else attempted to do this?  If so, any help you could give would
be appreciated.

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---