RE: How to use LIBL in connection string.

If I use Lib names separated by commas, then will my unqualified
sql will search this libl??

        According to the manual, no. It will assume the first lib as the
default lib for any unqualified sql statement.

        I want to avoid using hard coded libl all together and I want
the unqualified sql statement to search the libl of the
        job calling the Java pgm.

        I think what Ashish is doing is what I want to achieve. Just
thought it might be possible to specify the user libl in
        the connection string.

        maybe not!!!

        rgds,

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Franco Biaggi
Sent: 28 July 2005 19:20
To: Java Programming on and around the iSeries / AS400
Subject: Re: How to use LIBL in connection string.


This work fine from long time ago:

DatabaseURL=jdbc:as400://10.1.1.1;transaction
isolation=none;naming=system;libraries=lib1,lib2,qgpl,qtemp;block
size=128;extended dynamic=true;package=MYPKG;package cache=true;package
library=qgpl