|
From: Erwan D. <erw...@gm...> - 2013-03-12 10:41:01
|
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 <dan...@gm...> > 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
