|
From: Dan <dan...@gm...> - 2013-03-12 17:50:21
|
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 <erw...@gm...>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 <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 >> >> > > > ------------------------------------------------------------------------------ > 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 > > |
