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

["Alex Pinsky" <apinsky@xxxxxxxxxxxxxxx>]

And you need to drop *LIBL from your SQL statement...
Alex

-----Original Message-----
From: Franco Biaggi [mailto:fbiaggi@xxxxxxxxxx]
Sent: Thursday, October 30, 2003 9:55 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Using *LIBL/table name in SQL statements?


Chad,
you could use:
jdbc:as400://10.1.1.1;naming=system;libraries=mylib,qgpl,qtemp

The user current library is automatically set at beginning.
Hope this helps.

On Thu, 30 Oct 2003 07:41:45 -0700, cornelius, chad wrote:

>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 messages was scanned for malicious contents ***
-----------------------------------------------------------------------------
Franco Biaggi
CH-6807 Taverne

_______________________________________________
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.