Re: RPGLE STORED PROCEDURES

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Cary,

For your RPGLE member do something like:

  * Declare a cursor for the result set
C/Exec SQL
C+   Declare csMain For
C+   Select * From MyFile
C+   For Fetch Only
C/End-Exec

  * Open the cursor
C/Exec SQL
C+ Open csMain
C/End-Exec

  * Return with the result set
C/Exec SQL
C+ Set Result Sets Cursor csMain
C/End-Exec

Then you'll need to declare the stored procedure with an SQL statement:

Create Procedure ProcLib/ProcName
Language RPGLE Not Deterministic Reads SQL Data
External Name PgmLib/PgmName

Of course, you can also use OpsNav for the "CREATE PROCEDURE" statement.


Regards,

John Taylor
Canada

----- Original Message -----
From: "Kellems, Cary" <cary.kellems@nissan-usa.com>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, August 10, 2000 11:41
Subject: RPGLE STORED PROCEDURES


> Has anyone created an RPGLE program than returns a result set for a stored
> procedure.  I am unable to use SPL because I have no C compiler.
>


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---