×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"libraries": Specifies one or more libraries that you want to add to
*or replace* _the library list_ of the server job; List of server
libraries, separated by _commas_ or _spaces_; default: "*LIBL"; When you
do not use *LIBL, the specified libraries *replace* the current library
list of the server job;
http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.iseries.toolbox.doc/jdbcliblistproperty.htm
I was not aware of the implied behavior as noted in the last
statement above about *replace*.
As far as I know, the comma-separated list is used to prepend the
list with a single comma, to effect the *replace*. See also:
7. Library property specified, _list starts with a comma_; System
Naming: No default schema, all libraries on list searched, list replaces
job's library list.
http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/topic/com.ibm.etools.iseries.toolbox.doc/jdbcliblistproperty.htm#jdbcliblistproperty
As such, I suggest trying to replace the current attempt:
libraries=,QTEMP,MYLIB,QGPL,MYLIB2
IMO the documentation is very poor. I find it disturbing that
something as simple as the concept of a library list, is described in a
JDBC FAQ as "complicated." Implying that the "behavior of library lists
on an i5/OS system is quite complicated." To me, the complication is in
their poor implementation and *very vague* documentation. So unclear,
they have to have a long entry in a separate FAQ document;
http://www-03.ibm.com/systems/i/software/toolbox/faqjdbc.html Even more
disturbing, is that the FAQ is basically just a repeat of the already
poorly worded documentation.
I would open a defect issue with your service provider. Given the
stated results, the "libraries" property appears not to work as it is
documented: "When you do not use *LIBL, the specified libraries replace
the current library list of the server job." If that quoted
documentation is correct, then the traced results should not show any
ADDLIBLE errors, because the implementation should be, instead of any
ADDLIBLE activity, one request to:
*SYSTEM/CHGLIBL ( QTEMP MYLIB QGPL MYLIB2 ) CURLIB(*SAME)
Regards, Chuck
midrange.com
