Problem calling a stored procedure from a Java program
CREATE PROCEDURE P1 (IN PARM1 CHAR(7), PARM2 CHAR(12)) RESULT SETS 1 EXTERNAL NAME dcheri/SHIPBUILD PARAMETER STYLE SQL LANGUAGE RPGLE;The external program was compiled as a module and then a program object was created using CRTPGM PGM(DCHERI/SHIPBUILD) ACTGRP(*CALLER). Please let me know what I am doing wrong.
1. Apply the latest Database Group PTF on the server and make sure you have the latest fixes for the JDBC driver that you're using.
2. Try calling the stored procedure from the iSeries Navigator Run SQL Script window -- this interface will automatically display a window containing the contents of your result set. Java is used by iSeries Navigator to do this, so that can you help determine if it's a problem with your Java code.
3. Review your code to see if the parameter style specified is correctly implemented in your RPG code. The Redbook Stored Procedures, Triggers and User Defined Functions on DB2 Universal Database for iSeries is a good resource.
Dig Deeper on DB2 UDB (universal databases)
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our AS/400 experts
View all AS/400 questions and answers
Start the conversation
0 comments