Re: Stored Procedure? with Result Set.

[keith_mccully@xxxxxxxxxxxxxxx]

>I would like to issue a sql command (my guess is, a stored procedure), but
I
>might be wrong...  But I would like to execute a RPGLE program, that would
>create a muliple line result set, that can be passed pack to the calling
SQL
>statement.   But I would like to use native IO commands in the RPG
program,
>reade and chains...

Tim,

To do this you need to create an EXTERNAL stored procedure in SQL RPG. This
is just an SQL RPG program (optionally using native IO commands) which is
fronted by a SQL CREATE PROCEDURE statement.The RPG returns a declared
multi-occur data structure as the result set.

For a good RPG ref check the red book 'stored procedures and triggers'.

http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246503.html?Open


The only problem I have with this is that it seems that you are forced to
declare the result set size ie. no of data structure occurances at compile
time. Fortunately, my result sets are small! However, I seem to remember a
previous discussion on dynamically allocating size or perhaps not??

Cheers,

Keith