Re: SQL Stored Procedures

You can define the files in RPG to be "user open",
and then set the overrides based on parms passed with a call to qcmdexc api.
Jim Franz

----- Original Message ----- From: "Mike Cunningham" <mcunning@xxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Monday, September 22, 2008 11:20 AM
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.

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