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
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... 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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.