Re: using a DS with a stored procedure

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

I don't know of any way for a stored procedure to receive multiple rows 
of data in a single call.

You could have a stored procedure that accepts a big string of data, 
though.  That string could contain an XML document, or some similar 
method of encapsulating many rows into a single string.

Or you could call the stored procedure separately for each row.

Or you could use a web service instead of a stored procedure...



On 8/22/2013 9:20 AM, RPGLIST wrote:
> I'm looking at using a stored procedure (which references an existing
> RPGLE program) for connecting to an external process. I would need to be
> able to send multiple rows.
>
> 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.
>
> Is this even possible? I was thinking of just defining the full length of
> the data structure and using that as a clob field or something along that
> lines but it doesn't sound very efficient.
>
> Websphere and a web service is not an option, the owner flat out shot down
> spending the money for that.  So I'm back to square one.