RE: External Stored Procedures / Library Lists -- MIDRANGE-L

How can I change the library list for my CGI program?

This can be done using the SetEnv directive with the QIBM_CGI_LIBRARY_LIST environment variable and a list of the libraries. Be sure to uppercase the library names and separate them by semi-colons. For example:
SetEnv QIBM_CGI_LIBRARY_LIST "MIME;CGIURL;CGILIBL"
The listed libraries replace the libraries in the user part of the library list. When the CGI program has finished processing, these libraries will be removed from the library list and the library list will be restored to what it was before the CGI program ran.

From http://www-03.ibm.com/servers/eserver/iseries/software/http/services/faq.html#cgilib

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alfredo Delgado
Sent: Monday, August 06, 2007 4:39 PM
To: Midrange Systems Technical Discussion
Subject: Re: External Stored Procedures / Library Lists

As far as PHP I found this:
http://www.ibuildings.nl/blog/archives/62-PHP-for-IBM-i5-how-to-control-your-library-list-from-PHP.html

However, we're dragging our feet on updates so we're still not on Zend Core.

What's the Apache directive you mentioned?

Thanks,
Alfred

Mike Cunningham wrote:

There is a setting in both Websphere (java) and Apache (CGI) that lets you control the library list for that instance. We have a test and production version of both and set the library list at that level.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
Sent: Monday, August 06, 2007 3:18 PM
To: Midrange Systems Technical Discussion
Subject: RE: External Stored Procedures / Library Lists

Has anyone run into this before? How would I specify the library list
for the RPG III program to execute with when executed via the SQL
procedure?

Why would you want to? Seriously... Why can't the caller (PHP
connection) set the correct library list? To me the whole point of a
library list is so I can have a program in development, test and
production w/out having to change what libraries it looks at for data.
If you somehow embed the library into the program (either hard coded, or
from data-area, table, etc.) then you have another artifact you need to
promote and synchronize w/production.

Any calls to RPG we've done from the web (java and .net in our case)
have relied on setting the library list on the connection string. I
don't know PHP, but I'd guess (hope?) you have a similar option.

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)

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

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