|
From: Erwan D. <erw...@gm...> - 2013-03-12 18:08:31
|
So it worked? I think the explanation page is worth reading and understanding, so: On the Java Toolbox general page, follow JDBC / Ibm toolbox for Java JDBC Properties . This page is already interesting, but follow JDBC Librarylist property at the bottom of the page, and you should get it. Erwan 2013/3/12 Dan <dan...@gm...> > 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 >> >> > > > ------------------------------------------------------------------------------ > 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 > > |
