http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp
<http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp>






Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. 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]




________________________________

From: Kristipati Pavan
[mailto:db2udbdba-ezmlmshield-x46386652.[Email address protected]
Sent: Thu 10/19/2006 3:24 PM
To: LazyDBA Discussion
Subject: clustered index.

Gurus,
I need to create a clustering index. I know I can create only one
clustered index on a given table. But, can this clustered index include
multiple columns? I am not planning to include primary key in this
column list as I know I would need to do this while creating table.
When I refer to syntax for creating clustering index, I am not getting
it right. There are no examples that I could find to create clustering
index from a clp.
Any input would be v useful.
Version: DB2 V8.2
Thanks.


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

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