Re: using a DS with a stored procedure

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.

--
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.