Re: Censoring SQL access -- ideas?

On 3/25/11 4:40 PM, James Lampert wrote:

<<SNIP>> And in SQuirreL SQL from my WinDoze box, I have no idea
how to get it to see objects in [<ed:> library] MERCURY.

For an effective executable the SQL PATH [along with "function resolution" for the UDTF snipped from the quoted text, for example] is what is used to locate unqualified objects, while the default SCHEMA is used to locate most other objects.

function resolution:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzfuncres.htm

Whatever the interface to the server from SQuirrel, there may be a means to establish PATH and SCHEMA other than SET PATH and SET SCHEMA statements [at least the latter] per "Table 1. Default Schema Interfaces" at:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzqualun1.htm

If defaulting to *SQL naming, the simplest means to ensure visibility to the objects in library MERCURY is to access [CONNECT to] the server using the SQL authorization identifier [system user profile name] MERCURY.


FWiW some links follow, duplicates included, but the encompassing parent topic [that starts with differences noted for *SYS versus *SQL naming] is listed last:

InfoCenter search on SQL PATH gave as top hits:

sql path:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzpath.htm
current path:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcurpath.htm
set path:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzsetpath.htm
Unqualified type, variable, function, procedure, and specific names:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzqualun2.htm

Indirectly from the above, the topics:
Unqualified alias, constraint, external program, index, nodegroup, package, sequence, table, trigger, view, and XSR object names:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzqualun1.htm
Parent topic: Qualification of unqualified object names:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzqualun.htm

Indirectly from the above, the topic:
Parent topic: Naming conventions:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzch2nam.htm

Regards, Chuck