RE: using a DS with a stored procedure

["RPGLIST" <rpglist@xxxxxxxxxxx>]

You did not Steve,
the .net is sending the data, the iseries side is processing and sending
back a line by line response code.


> This will send data...i thought he was talking of receiving it.
>
> Because of the line:
>
> " We have a windows app that would call a stored procedure and pass it
> approximately 59 fields of data, but it can contain up to 99 rows of
> data."
>
> I thought the windows app was sending the data, not the other way round.
>
> I apologize if I misunderstood the question.
>
> Steve Needles
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Justin Taylor
> Sent: Thursday, August 22, 2013 11:33 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: using a DS with a stored procedure
>
> Are you looking at returning the DS as the result set?  If so, that's no
> problem.  Just load a DS array and return it.  Here's the RDp snippet I
> use for the return:
>           EXEC SQL  SET RESULT SETS ARRAY :${Data Structure} FOR :${Rows}
> ROWS;
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (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.
>
>
> ________________________________
> This communication, including attachments, is confidential, may be subject
> to legal privileges, and is intended for the sole use of the addressee.
> Any use, duplication, disclosure or dissemination of this communication,
> other than by the addressee, is prohibited. If you have received this
> communication in error, please notify the sender immediately and delete or
> destroy this communication and all copies.
>
> TRVDiscDefault::1201
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (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.