RE: Returning a Results Set from a Stored Procedure

Set up a multiple occurrence data structure:
D OData DS Occurs(1000)
D OData_Record 128
D OData_Date 8
D OData_Time 8

Keep track of the number of times it is filled.
Then when done filling the mods:
Exec SQL Set result sets array :OData FOR :Count ROWS;
When you create the stored procedure:
Create Procedure NAME
(IN :@Parm1 Character (10),
IN :@Parm2 Character (10))
Result Sets 1
Language RPGLE
Not Deterministic
Modifies SQL Data
External Name QGPL/GETDTAQ
Parameter Style General

HTH,

Craig


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DebbieKelemen
Sent: Tuesday, August 12, 2008 2:15 PM
To: 'Midrange Systems Technical Discussion'
Subject: Returning a Results Set from a Stored Procedure

I hope this is the right group to ask maybe not. However, I will start
here. I want to create a Stored Procedure which will be used by a windows
form application. To present the data quicker I want to use an RPG program
underneath the covers. How can I return a result set from an RPG program?
I am used to sending all of my fields back as individual parms. The
programmer developing the windows form application has asked for a single
result set. We do this with SQL all the time however the data we are going
after is in multiple files and it is single record time access which has
better performance with RPG.



Can someone point me in the right direction?



Debbie Kelemen

Sr. Programmer / Analyst

CHEFS

719-272-2617

dkelemen@xxxxxxxxxxxxxxxx

www.chefscatalog.com