Re: External Stored Procedures with Imbedded sqlrpgle

[Alan Campin <alan0307d@xxxxxxxxx>]

You need a result set. Return either by a Cursor and Select or a Set
Results Sets from an array. Either way.you need some SQL.

On Wed, Apr 22, 2009 at 10:29 AM,  <DLee@xxxxxxxx> wrote:
> I'm working on retreiving a list of names and policies for an application
> that will pass the data to a network C# program.
>
> In coding the sqlrpgle, I realizing I don't know quite how to return the
> data to the stored procedure.
>
> I have an *entry setup that looks like this  ( I know, old code) that has
> basically last name, first name, policy
>
>     C     *ENTRY        PLIST
>     C                   PARM                    LNAM
>     C                   PARM                    FNAM
>     C                   PARM                    POLM
>
> Darrell Lee
> Information Technology
> Extension 17127
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.