Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Unanswered: need help for range partition

    can any one help how to write a generalized query for a table partition in db2 using range scheme.
    After going through few docs i got a example using hash scheme,i.e:
    db2 "SELECT COLNAME, PARTKEYSEQ FROM SYSCAT.COLUMNS WHERE TABNAME = '<TableName>' AND PARTKEYSEQ != 0 \
    ORDER BY PARTKEYSEQ"
    I also need the same as above for a range partition

    thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check SYSCAT.COLUSE
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Nov 2009
    Posts
    2
    could u plz send the exact query as above ....so that it can be used in an application

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Can you send me your pay cheque ?

    Quote Originally Posted by ravisrip View Post
    could u plz send the exact query as above ....so that it can be used in an application
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by sathyaram_s View Post
    Can you send me your pay cheque ?
    Hey, I was here first!

    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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