Re: Stored Procedures

The 'SET RESULT SETS CURSOR' statement is extraneous. You don't need it,
OPEN will suffice.

Code you've listed below looks good to me.

Perhaps problem is with the naming convention setting in the Run SQL Scripts
(you're using *SQL and perhaps it's set to *SYS)? You can change it by
clicking on the following dropdown:

Connection-->JDBC Setting-->Format-->Naming convention

Also, in Run SQL Scripts statements end with semicolons so your final END
should have a semicolon at the end.

If it still doesn't work in iNav, post full CREATE PROCEDURE code you've
used as well as the actual error text from the message screen pane on the
bottom of Run SQL Scripts.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: [SystemiDotNet] Stored Procedures

Try creating this SQL procedure (with your own tables)

IN Parameter CustomerNumber Integer

This code throws an error CUR1 is not defined for the 1st line...
--------------------------------------
DECLARE CUR1 CURSOR FOR
select * from some_table where cusno = CustomerNumber;
OPEN CUR1;
SET RESULT SETS CURSOR CUR1;
---------------------------------------