MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » February 2008

Re: JDBC Connection and Library List (I have code for testing)



fixed

What I saw on v5r3 showed successive requests to "ADDLIBLE LIB(name)" via SQL CALL requests performed in a QRWTSRVR job:
CALL QSYS/QCMDEXC('ADDLIBLE LIB(name)', 0000000018.00000)

Thus not only is that problematic for its failure to use the more appropriate QSYS/CHGLIBL, it is incorrectly using *LIBL/ADDLIBLE and failing to ensure its assumption of POSITION(*FIRST) is met.

The above implies two issues. First that the command request is not library qualified. Second that the assumption of *FIRST could become a *failed* assumption on any system where the following customization has occurred [a defect, more than just an 'issue']:
CHGCMDDFT QSYS/ADDLIBLE 'POSITION(*LAST)'

Because of the first error, you could get past the problem by introducing a Trojan Horse command BEFOREQSYS/ADDLIBLE which effects the desirable outcome of library placement; e.g. using a CLP which monitors the condition of CPF2103 and reacts by RMVLIBLE of the same value for LIB(), and repeats the ADDLIBLE LIB() POSITION(*FIRST)

Report those issues as defects and suggest the most appropriate resolution would presumably be to use CHGLIBL like is done in the other case. FWiW the use of CHGLIBL in the other case probably also has the same coding issue whereby it is not library qualified by *NLVLIBL or *SYSTEM.

Regards, Chuck





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact