Well, well, well!
It's JAMES PARK! Hehe. How have you been? If you have everything in
one file (dataset) in SPUFI or QMF, you just need to put set CURRENT
SQLID = 'AB' at the top (first line) of your dataset.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x16195448.[Email address protected]
Sent: Wednesday, August 29, 2007 11:08 AM
To: LazyDBA Discussion
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