Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Question Unanswered: IBM DB2 working with indexes

    DB21085I Instance "db2inst" uses DB2 code release "SQL07025" with level
    identifier "03060105" and informational tokens "DB2 v7.1.0.68", "s020616" and
    "U484487".

    OS: Unix

    Hi, I'm trying to figure out, how to select all the tables from db which have at least one unique index.

    Maybe someone could help.

    Thank you.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My V7 memory is rather rusty, since it went out of support about 3 years ago. But try something like "select distinct tabschema,tabname from syscat.indexes where uniquerule in ('P','U')".

    Andy

  3. #3
    Join Date
    Mar 2009
    Posts
    2
    Thanks, that filled the gap I was stuck on.

Posting Permissions

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