Re: multi-tenant issues with stored procedures

On Thu, Nov 30, 2017 at 10:54 AM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

The reference I posted doesn't mention that. Is there a reference that
you know of that documents this behavior to be dependent upon the client?

I googled and found a number of references on IBM sites about ODBC and JDBC
connection properties that discuss ways for clients to specify the library
list of the database server Job (QZDASOINIT, QSQSRVR, etc.), depending on
the "driver" used.

Following is one reference that discusses the "libraries" connection
property in one of the JDBC drivers:

https://www-03.ibm.com/systems/power/software/i/toolbox/faq/jdbc.html#faqC10

I know it's only empirical evidence, but I've been relying on this
profile switching behaviour for more than 10 years, and with a variety
of clients from .NET to Java and a lot in between. If my... success is
accidental, I'd like to know about it!

I understand profile switching, when you connect using different user
profiles, but I'm afraid I still don't understand the effect on library
list.