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!

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.