Once at the top and it will stay in effect until you disconnect or issue
another set current sqlid





"JAMES PARK "
<db2udbdba-ezmlms
hield-x16195448.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
08/29/2007 10:07
AM Subject
SET CURRENT SQLID = 'ADB'










Esteemed Listers,

DB2 V7 on z/OS.

I have bunch of DDLs that create tablespaces, indexes, tables and issuing
grants in PDS.
In order to create all these objects with a particular owner ADB, should I
include SET CURRENT SQLID = 'ADB' in every DDL or can I set CURRENT SQLID
only once at the top?

Thanks,

James Park
Database Specialist II
Annapolis Data Center
410-260-7489
[Email address protected]




------------------------------------------------------------------------------

This email and any file transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you received this email in error, please notify the
Comptroller's System Manager by forwarding this message to [Email address
protected]
==============================================================================




This footnote also confirms that this email message has been swept by the
networkmaryland MIMEsweeper for the presence of computer viruses.

**********************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page