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)
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading