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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.