RE: Returning a Results Set from a Stored Procedure

Could I return a data structure as a single parm like a result set?

You could return a DS as a single parm, but that's a parm, not a result
set. Additionally, the consumer would then have to split apart your
datastructure on their end. And don't forget that parm will go through
EBCDIC/ASCII translation so don't go sticking any numeric values in
there.

If they can eat parms, use parms. If they need a result set, use a
result set.

Can you give us more details about the number/type of columns? And I
assume there would be only 1 row since you are thinking about using
parm, yes?

-Waden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


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

Could I return a data structure as a single parm like a result set?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DebbieKelemen
Sent: Tuesday, August 12, 2008 12: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