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

[Alfredo Delgado <adelgado@xxxxxxxxxxxxxxxxx>]

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.