×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




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-2026 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.