RE: Using *LIBL/table name in SQL statements?

Thanks...  I am using Tomcat and have defined a generic username and
password that is used to connect in the server.xml file.  I will see if we
can just add the libraries we need to this username.  Thanks for the
insight.

Thanks,
Chad


-----Original Message-----
From: Adam.Martin@xxxxxxxxxxxx [mailto:Adam.Martin@xxxxxxxxxxxx] 
Sent: Thursday, October 30, 2003 7:52 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Using *LIBL/table name in SQL statements?

Chad,

It should automatically use the library list of the user id that you 
connected with.

Adam





"cornelius, chad" <chad.cornelius@xxxxxxxxxxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
10/30/2003 09:41 AM
Please respond to Java Programming on and around the iSeries / AS400 

 
        To:     "'JAVA400-L@xxxxxxxxxxxx'" <JAVA400-L@xxxxxxxxxxxx>
        cc: 
        Subject:        Using *LIBL/table name in SQL statements?


Does anyone know if it is possible to use some thing similar to 
*LIBL/table
name in SQL statements?  I know explicitly defining library/table name
works, but I need to read from a user's current library list, which defers
from location to location.  Any help would be greatly appreciated.

 

Thanks,

Chad

 

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.