Re: Callable Statement

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Barry,

You wrote:
>When I run this I get an [sql0204] JavaCall2 in zzbm1 type N* not found.
>If I take out the parameters on both the Java pgm and the AS400 CL pgm it
>works fine.
>Any ideas.

Did you remember to run CREATE PROCEDURE to describe the parameter
interface to SQL?  Something like:

 CREATE PROCEDURE zzbm1.javacall2 ( IN ID        CHAR(3),
                                    IN NUMBER    CHAR(10) )
        EXTERNAL NAME zzbm1.javacall2
        LANGUAGE CL GENERAL;

Also, check the joblog of the associated QZDASOINIT while the procedure is
running to see any error messages.  You may have to service the job and
put it in debug to see all the messages.

Regards,
Simon Coulter.

--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists
   http://www.flybynight.com.au/

   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------