You can also create separate logins for each environment and set the library list properly for each environment.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Alfredo Delgado
Sent: Thursday, April 23, 2009 11:42 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] How can web PHP and SQL change the IBM i library list?

You can't have a cascading list a la IBM i with the DB2 API. If you use the
i5 toolkit then you can set it in the connection as a space delimited list
in I5_OPTIONS_INITLIBL.

e.g. i5_pconnect( SYSTEM, USER, PASSWORD, array( I5_OPTIONS_INITLIBL=>'PROD
STAGE QA' ) );

You can also issue a chglibl command after the connection.

Alfred

On Thu, Apr 23, 2009 at 11:21, <elehti@xxxxxxxxxxxxxxxxxx> wrote:

How do you web developers enable use of the IBM i library list, so that
your web SQL statements do not need to specify Library names where each
table is located?
Our web developer hard-codes library name (library.table) on each SQL
statement because he does not know how to change a job library list
(INLLIBL parameter (Initial Library List) on the job description.)

Each of our IBMi environments (production, Development, Customer Test,
Modeling, Budget) have approximately 15 libraries in each.

Do you modify the INLLIBL parameter (Initial Library List) of the web
user job description?

I would like to make it easier for our Intranet web applications to
switch easily to various environments on our System i .

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.





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