× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.