Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008

    Question Unanswered: syntax to set identity key in an existing column

    hello everyone,

    Im new with DB2, I need help in setting up an identity key into my existing column. can you give me the proper syntax on how to do it.



  2. #2
    Join Date
    May 2003
    I am not sure what you are trying to do, but please consult the SQL Reference Manual Vol 2, for ALTER TABLE.

    Here is a link to the manuals, which lets you first select the version of DB2 you are using (DB2 for Linux, UNIX, Windows).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2008
    Hi marcus thanks for replying. here is exactly what i want to do

    I would want the identity to be set in master table
    and in transaction tables i will refer this key as foreign key but i would not want to add a new column in my existing table what I want is to set the existing column in my table as the identity key

  4. #4
    Join Date
    Jan 2003
    Provided Answers: 5
    You should be able to do what you want. As Marcus stated, please review the ALTER TABLE SQL statement to perform what you want.


Posting Permissions

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