Results 1 to 6 of 6

Thread: db2 manual

  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: db2 manual

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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2 manual

    SQL Reference ...

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

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    Re: db2 manual

    Thanks!


    Originally posted by sathyaram_s
    SQL Reference ...

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

    Cheers
    Sathyaram

  4. #4
    Join Date
    Dec 2003
    Location
    Johannesburg, South Africa
    Posts
    18

    Wink IBM

    IBM Sql Guide

    Syntax for Table Creation

    CREATE TABLE owner.tablename
    Divvy

  5. #5
    Join Date
    Dec 2003
    Location
    Johannesburg, South Africa
    Posts
    18

    Wink IBM

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

  6. #6
    Join Date
    Dec 2003
    Location
    Italy
    Posts
    11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •