RE: How to use LIBL in connection string.

No, you can't use %LIBL%. Direct quote from the documentation:

"The server uses specified libraries to resolve unqualified stored procedure 
names, and stored procedures use them to resolve unqualified names. To specify 
multiple libraries, use commas or spaces to separate individual entries. You 
can use *LIBL as a placeholder for the current library list of the server job"

In other words, it's *LIBL not %LIBL%.

PC2

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On 
Behalf Of Anand, Rajesh
Sent: July 28, 2005 01:51
To: java400-l@xxxxxxxxxxxx
Subject: How to use LIBL in connection string. 

Folks,

        I've seen in the list people talking about this but not found a 
solution.

        I want to use a %LIBL% in my connection string as below.

        Connection con =
DriverManager.getConnection("jdbc:as400://mldev400;libraries = %LIBL%; date 
format = iso" , "*CURRENT", "*CURRENT");

        However, when I run the pgm , it always uses mylib as opposed to %LIBL%.

        How can overcome this problem. Can I also use *LOCAL instead of 
'mldev400' name of our system???

        Thanks in advance.

        

Rajesh Anand