Modifying tables to support the ROWID function, using a DB2/400 database
To modify tables to support the ROWID function, using a DB2/400 database:
1. Add a column with identify characteristics named PROGRESS_RECID. Thew new column must be able to contain null. For example:
alter table table add PROGRESS_RECID bigint GENERATED ALWAYS AS IDENTITY
(START WITH 1 INCREMENT BY 1)
DB2/400 data sources do not require a trigger or stored procedure to generate the identity value since a value is generated by the system for the identity column automatically.
2. Change the nonunique indexes so that they include a PROGRESS_RECID column as the last component. For example:
create index table##index on table (column, PROGRESS_RECID)
3. If you have already created your schema holder, update it to reflect your changes to the data source table.
