In whic manual can I find syntax for table,index creations ?
I didn't find in command ref. manual.
thanks!!

SQL Reference ...

You can find link to the IBM technical info page at www.db2click.com

Cheers
Sathyaram

Thanks!

IBM Sql Guide

Syntax for Table Creation

CREATE TABLE owner.tablename

IBM Sql Guide

Hereis an Example:

Database Name is TSTDB01
Table SPace Name is TSTEST
Table NAme is TBTEST
Table/ Index Owner is TEST
Index Name is X1TEST_TKTNUM

CREATE TABLE TEST.TBTEST
( TKTNUM CHAR(14) NOT NULL,
TKTSEQ SMALLINT NOT NULL,
FOCLIST INTEGER NOT NULL,
ODORG CHAR(03) NOT NULL,
ODDES CHAR(03) NOT NULL,
ODFLAG CHAR(01) NOT NULL,
DEPDTM TIMESTAMP NOT NULL)
in TSTDB01.TSTEST ;

CREATE TYPE 2 INDEX TEST.X1TEST_TKTNUM
ON TEST.TBTEST
( TKTNUM ASC ,
TKTSEQ ASC )
USING STOGROUP TXTSG00
PRIQTY 11000
SECQTY 1100
ERASE NO
FREEPAGE 20
PCTFREE 15
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE NO
PIECESIZE 2 G ;

you can go here too:

http://www.pdc.kth.se/doc/SP/manuals...s0/db2s003.htm

rosario