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