Re: How can web PHP and SQL change the IBM i library list?

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.