DSNAOINI CURRENTSQLID question

Tim Hare

DSNAOINI CURRENTSQLID question

If I code CURRENTSQLID in the data source section of DSNAOINI (see below)  can I do SELECT with unqualified table names, and have the qualifier default to current SQL ID as set in the parameter,  or will it default to the primary authorization ID from the ACEE ?

DSNAOINI:
[COMMON]                            
MVSDEFAULTSSID=DSNZ                 
                                    
[DSNZ]                              
MVSATTACHTYPE=CAF                   
PLANNAME=DSNACLI                    
[LOC1]                              
AUTOCOMMIT=0                        
CONNECTTYPE=1                       
CURRENTSQLID=DB2SPEC                
SCHEMALIST="'DB2SPEC',CURRENT SQLID"

Peter Conlin

RE: DSNAOINI CURRENTSQLID question
(in response to Tim Hare)

Tim,

I have the following DSNAOINI file.  When I connect to DBCA my unqualified table owner is DB2PROD, when I connect to DBCD, my unqualified table owner is DB2TEST (n.b. square brackets are translation victims in stanza headers.)  FYI, doc indicates you may have to use MVSATTACHTYPE=RRSAF with multiple simultaneous connections.

Good luck.

Peter

ÝCOMMON¨                            

MVSDEFAULTSSID=DBCA                  

ÝDBCA¨                              

MVSATTACHTYPE=RRSAF                  

PLANNAME=DSNACLI                    

ÝLOCDBCA¨                            

CLIENTUSERID=DB2PROD                

CURRENTSQLID=DB2PROD                

RETURNSYSNONYMSCHEMA=1              

SCHEMALIST="'DB2PROD',CURRENT SQLID"

;                                    

ÝDBCD¨                              

MVSATTACHTYPE=RRSAF                  

PLANNAME=DSNACLI                    

ÝLOCDBCD¨                            

CLIENTUSERID=DB2TEST                

CURRENTSQLID=DB2TEST                

RETURNSYSNONYMSCHEMA=1              

SCHEMALIST="'DB2TEST',CURRENT SQLID"

CLIENTUSERID=DB2TEST                

;                                    


 
In Reply to Tim Hare:

If I code CURRENTSQLID in the data source section of DSNAOINI (see below)  can I do SELECT with unqualified table names, and have the qualifier default to current SQL ID as set in the parameter,  or will it default to the primary authorization ID from the ACEE ?

DSNAOINI:
[COMMON]                            
MVSDEFAULTSSID=DSNZ                 
                                    
[DSNZ]                              
MVSATTACHTYPE=CAF                   
PLANNAME=DSNACLI                    
[LOC1]                              
AUTOCOMMIT=0                        
CONNECTTYPE=1                       
CURRENTSQLID=DB2SPEC                
SCHEMALIST="'DB2SPEC',CURRENT SQLID"