Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Unanswered: Help on inserting on identity column


    I wanna add ID column in my table which would be identity and from 1 to 478.
    How can i insert it?

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Since you didn't provide any details, I'm guessing that
    (a) you are using DB2 LUW,
    (b) you have Version 8 installed.

    If so, here are a few pointers:
    The documentation for the ALTER TABLE statement states explicitly:
    identity-options This clause cannot be specified when adding a column to an existing table.

    Searching the DB2 manuals for identity columns also finds this introduction.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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