RE: Stored Procedure Calls

["Tanveer, Mohammad" <MTanveer@xxxxxxxxxxxxxxxx>]

When I call my stored procedure using jdbc and don't set LR on in RPG
program.  It seems like my next call using the existing instance of the RPG
program and if multiple calls are executed to the same procedure it seems
like OS/400 is creating multiple threads of the same job.

Is it a true analysis?

-----Original Message-----
From: Price, Chris [mailto:chris_price@nsb.co.uk]
Sent: Tuesday, June 11, 2002 2:49 PM
To: 'java400-l@midrange.com'
Subject: RE: Stored Procedure Calls



All client Stored Procedures calls, along with all JDBC operations are batch
through the Toolbox.

I think that only if the Java App is running on the iSeries/AS400 in an
interactive 5250 session, then the JDBC calls will probably also be
interactive (perhaps one of the Toolbox guys could confirm this?)

Chris

 -----Original Message-----
From:   Tanveer, Mohammad [mailto:MTanveer@friedmancorp.com]
Sent:   11 June 2002 20:37
To:     'java400-l@midrange.com'
Subject:        Stored Procedure Calls

Stored Procedure Calls using JDBC drivers are interactive jobs on AS/400 or
Batch Jobs?  If interactive is there any study on performance issues using
stored procedures?

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.