If by chance you want mixed case column names, DB2 will let you do so by
enclosing the column name in double quotes.

A word of advice from someone that picked up support of several database
where mixed case column names were used. Don't use mixed case unless you
have a darn good business reason for it. It is a pain to maintain.

Al Glinter, Lead Database Administrator
Lord & Taylor
I.T. Solutions Center
611 Olive Street, 19th Floor
St. Louis, MO 63101
314-342-6800 X-3389




"Tsai Chiali " <db2udbdba-ezmlmshield-x46026060.[Email address protected]
08/29/2007 01:33 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: SET CURRENT SQLID = 'ADB'






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


---------------------------------------------------------------------
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