Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    5

    Unanswered: SQL to compare the table with identity column

    Hi,

    How to write the DB2 SQL to compare if table with identity columns highest values matches with maximum values?

    Thanks,
    Vikram

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can figure out using the article
    DB2 System Catalog Views: Everything You Need to Know About Your DB Objects

    A hint : Identity columns are implemented internally as SEQUENCES.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2011
    Posts
    5
    Hi Satyam

    I would like to know the SQL for getting the maximum number of Identity columns.Is this possible?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Have you tried ?


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

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Exhaustive information on system catalog views

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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