Re: using a DS with a stored procedure

<<they would like a "real time" response back>>

In other words, writing records is too slow? What language are they using?

I am working on an open source project that would abstract the interface
away and provide for just sending and receiving unlimited messages between
client and iSeries. Send me a private e-mail if you are interested and I
will send you a document I have written up.


On Thu, Aug 22, 2013 at 9:57 AM, RPGLIST <rpglist@xxxxxxxxxxx> wrote:

I've suggested something along that line, but there is resistence since
they would like a "real time" response back to the calling app.

Hello, we had a similar requirement. How we handled this was for the
.NET
app to write to a physical file with a batchid as the key. The .NET
then
called the sp and passed the batchid.
The rpgle program then processed all the rows for the passed batchid.

This doesn't exactly answer your question but it may be an alternative
to
consider.

Rob
On 2013-08-22 10: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.

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