Re: looking for stored procedure example...

You can certainly return multiple values as multiple rows in a result set (that's what a stored procedure does: it returns a SQL result set). I'm not familiar with Cobol, but in RPG you can do it using a data structure. The drawback is that you have to
define your DS ahead of time to be big enough for all cases, so if you're not sure how many values you're going to get that can be a problem.

hth ...
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:

If you're talking a true SQL procedure, then you're out of luck. You cannot
pass an array of arguments to SP. If this is a character array, you MIGHT
be able to simulate it by passing in a very long char or varchar argument,
separated by commas or something.
As for an array output... I think that's possible, if you return a result
set. Or you could make your SP argument into an IN/OUT variable.
Of course, using an HLL like Cobol to parse the input/output argument would
be easier than using SQL.

In any case, SP doesn't sound like the right tool for this type or
request... perhaps you can restructure the task differently?

Hth, Elvis

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


-----Original Message-----
Subject: looking for stored procedure example...

List,

Can anyone share an example of a stored procedure written in either SQL or
COBOL that receives *and* returns an array of values? TIA!
--
Regards,
Michael Rosinger

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that any use is
strictly prohibited. If you have received this e-mail in error, please notify us immediately by replying to it and then delete it from your computer.