Thanks Erwan,

That link didn't work for me, took me to a general Java Toolbox page.  But I created a new connection and omitted the library name from the connection URL.

- Dan

On Tue, Mar 12, 2013 at 6:40 AM, Erwan Duroselle <erwan.duroselle@gmail.com> wrote:
Dan,

I think I got it: Try and remove /DANLIB from your connexion URL.

It related to the way the JT400 driver resolves the libraries list and default library, which is rather complex (not less than 20 different cases!)
See http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Frzahh%2Fpage1.htm

If I understood, you are in scenario 2/system naming but want to be in scenario 6/system naming.


HTH,

Erwan



2013/3/11 Dan <dan400man@gmail.com>
Using the JTOpen(AS/400) driver.  In the Alias properties, Driver Properties tab, I have checked "Use driver properties", selected "libraries" and provided the library list (multiple libraries separated by commas, no spaces).  Also, selected "naming" and chose "system".

The connection URL is jdbc:as400://MERCURY/DANLIB

When I attempt to run a simple "select * from policys" where "policys" is a table in a library found in the library list (but not library DANLIB), I get:
  Error: [SQL0204] POLICYS in DANLIB type *FILE not found.

When I qualify the table name (i.e., "select * from pmsprod/policys"), the query runs successfully.

Another interesting thing I noticed.  When typing the statement with the unqualified table name, I notice that the table name appears in red until I type the final character, when it turns green.  It appears to show me that it found the table in the library list.

I am qualifying all of my tables for now, but this is a major usability issue for me.  I really want to use the library list I set in the alias properties.  I've been playing around with various settings, trying to get this to work.  Searched online with no success.  (BTW, can someone show me how to search the archives of this list?)


------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users



------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users