Library List is set in the Configuration - Configuration Manager.
It is possible to define multiple Configurations. When connecting to the
System, the desired configuration is speciified.
Configuration Manager --> Select your connection and Edit (or create a new
one)
System --> Schema List (enter the library list here!)
Don't forget to switch to system naming conventions (Format --> Naming
Conventions)
After having saved the modified configuration.
Reconnect your system with the appropriate configuration.
In either way don't forget to reconnect after having done any modifications
in the configuration.
BTW: Default Schema is not the same as the Current Library in CL.
If a Default Schema is set, the library list is ignored (even if you are
using System Naming conventions).
All unqualified specified tables, views are searched in this Library.
BTW it is still possible to set/change the library list with the ADDLIBE,
RMVLIBE or CHGLIBL CL Commands.
CL: CHGLIBL LIBL(QTEMP YOUR1SCHEMA YOUR2SCHEMA QGPL);
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Freitag, 31. März 2017 06:58
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Navigator's Run SQL Scripts - setting a library list
I'm trying out Run SQL Scripts from ACS, but for the life of me, I can't
figure out how to set the library list.
I found the System tab in the JDBC Configuration dialog, The only choice for
the Default SQL schema drop down is "Use library list of server job".
I added my test library, which needs to be at the top of the library list,
to the Schema list. Hovering the mouse over the Schema list box causes a
help thingy to show "Specifies the list of schemas to add to the server
job's schema list. <snip> The schema list is used for resolving unqualified
names."
When I ran a query using unqualified table names, it used tables from our
production library, not my test library that I specified in the schema list.
The following query, in the same "Run SQL Scripts" session, shows my test
library at the bottom of the list:
SELECT * FROM QSYS2.LIBRARY_LIST_INFO
I changed the Default SQL schema to my test library, but this had no effect.
Yes, I googled, but all the results referenced the older version of Run SQL
scripts.
Ideas welcomed,
- Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
