Posted: 8 years 1 months 15 days 13 hours 43 minutes ago
I didn't read the article but returning an array from a SP sounds odd to me when you can return a result set which is basically an array of table rows with meta data attached to it.
Chris Ringer
Posted: 8 years 1 months 14 days 15 hours 29 minutes ago
A PROCEDURE returns an integer (or nothing), so technically, no. What they appear to be doing is using an "OUT" parameter as a way around this.
You must be thinking of executing this PROCEDURE from RPG, or something else not SQL. If you were using SQL you'd do a CREATE FUNCTION ... RETURNS TABLE.
Which begs the question, what are you trying to accomplish, that you need to return an array from a SQL PROCEDURE?
Posted: 8 years 1 months 12 days 9 hours 50 minutes ago
Sorry for dawdling. I was asked if it's possible to return an array from an sql stored procedure to an rpg program. From what I read, the answer is no, but we can get the job done using result sets, and that's what I answered. haven't heard anything more on it, and been to busy to ask.
Thanks for the response!