Re: multi-tenant issues with stored procedures

On 11/30/2017 4:39 PM, Nathan Andelin wrote:

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

This is overriding the library list in the JOBD. IBM security still
holds.

I thought we were talking about the situation where we have eg two
clients: .NET and JDBC. Each client is configured to have the
same/equivalent connection properties. It is my personal experience
that the server will always behave the same way, no matter which client
connects. That is, I don't get one library list with .NET and a
different one with JDBC. The server always uses the same rules to
establish the library list regardless of client.