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.

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


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