RE: Stored procedure that calls another program

Scott:
No, but the performance is terrible. On the client side the RGPLE program
does an SQL call to a stored procedure on the server. The server side
stored procedure then calls a few RPG program along the way. It just seems
to run VERY slow.
cjg

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Thursday, February 19, 2009 6:48 PM
To: Midrange Systems Technical Discussion
Subject: Re: Stored procedure that calls another program

Hi Carl,

Are you saying that an RPG CALL is running slower than invoking the same
program via an SQL CALL? That doesn't make much sense to me.

Carl Galgano wrote:

All, thanks for the replies.
Alan, you are correct, my stored proc is an RPGLE program, and it
calls other RPGLE programs directly using a CALL. I am not turning on
LR (using a return), but the performance seems to be slow.
The SQL itself is VERY fast.
cjg

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.2/1964 - Release Date: 02/21/09
15:36:00