Results 1 to 2 of 2

Thread: Rowid in db2

  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: Rowid in db2

    Hi,
    Can the concept of rowid cud be used in an existing table? If so, pls let me know some info abt it. I'm using DB2 7.2 on 0S390.

    Thanks!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't believe that it can be added to an existing table because adding a column to an existing table requires that nulls be allowed (the initial value right after the ALTER TABLE). ROWID requires a NOT NULL specification and DEFAULT cannot be used.

    So you would have to unload the table, drop the table, create the table with the ROWID column, and then load the table.

Posting Permissions

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