Don't worry about the "", it's all right.

-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x63374649.[Email address protected]
Sent: Wednesday, August 29, 2007 2:30 PM
To: LazyDBA Discussion
Subject: Re: SET CURRENT SQLID = 'ADB'

DB2 V7 on z/OS.

Below DDLs were generated from SMP/E.
Is the syntax of DDLs right? In my certification book I don't see object
names with double quotes. Can these objects be created?

CREATE DATABASE "ADBDCHG"
STOGROUP "ADBGCHG" CCSID EBCDIC;

COMMIT;

CREATE TABLESPACE "ADBSCHG"
IN "ADBDCHG"
USING STOGROUP "ADBGCHG"
PRIQTY 40 SECQTY 40;



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