Re: Censoring SQL access -- ideas?

[CRPence <CRPbottle@xxxxxxxxx>]

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