RE: SQL Stored Procedures

No. Not RPG. We are using Java to execute the SQL stored procedure.

We use Cobol on the iSeries. I created a Cobol procedure that submitted
the sql portion, but we could not get a result set to return to the Java.
In the SQL, we could not set the library.

Not sure what to do at this point.

Thanks,

Wes Taylor
Senior Programmer/Analyst - Message Processing
Comporium Data Services
(803) 326-4115
wes.taylor@xxxxxxxxxxxxx




Mike Cunningham <mcunning@xxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
09/22/2008 11:40 AM
Please respond to
Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>


To
"'java400-l@xxxxxxxxxxxx'" <java400-l@xxxxxxxxxxxx>
cc

Subject
RE: SQL Stored Procedures






Are you using SQL stored procedures or external stored procedure where the
procedure is an RPG application? If it is an external procedure then
using any of the traditional ADDLIBLE, CHGLIBL, or OVRDBF commands are
available to point to the correct library.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wes Taylor
Sent: Monday, September 22, 2008 9:42 AM
To: java400-l@xxxxxxxxxxxx
Subject: SQL Stored Procedures

My company and myself are new to this. We currently are creating java
classes that are building sql statments that are executed on the iSeries.
We have read that creating stored procedures on the iSeries will speed the
process up.

We can execute the sql procedure from our java class and return data. The
problem we are having is that we have 3-4 different libraries with the
same files in each. We need to pass a library/schema to the procedure via
a parm.

This is the procedure we created on the iSeries:

CREATE PROCEDURE SECLIB.test4
(IN companyId CHAR(8)) language SQL
DYNAMIC RESULT SETS 1
BEGIN
DECLARE C1 CURSOR FOR
select * from companyId.APYPFM01;

OPEN C1;
RETURN;
END

The companyId is the library/schema we need to be a variable.

Any suggestions would be greatly appreciated.

Thanks,


Wes Taylor
Senior Programmer/Analyst - Message Processing
Comporium Data Services
(803) 326-4115
wes.taylor@xxxxxxxxxxxxx

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