This section focuses on the DB2 Universal Database incompatibilities that we are reserving the right to do two versions in the future, following Version 6. Users of DB2 Universal Database are warned to code applications with these in mind, as well as to modify existing applications to make migration to future versions easier.
| UNIX | OS/2 | WIN | Extended |
The system catalog views will be read-only views. The SYSSTAT views will continue to be updateable.
UPDATE statements which used to work against columns in the SYSCAT views will fail.
Tools or applications are coded to change values in the catalog by updating the column as defined in the SYSCAT view.
Change the tool or application to change the catalog by updating the column as defined in the SYSSTAT view.
| UNIX | OS/2 | WIN | Extended |
The SYSCAT.REFERENCES columns PK_COLNAMES and FK_COLNAMES will no longer be available.
Column does not exist and an error is returned.
Tools or applications are coded to use the obsolete PK_COLNAMES and FK_COLNAMES columns.
Change the tool or application to use the SYSCAT.KEYCOLUSE view instead.
| UNIX | OS/2 | WIN | Extended |
The SYSCAT.INDEXES column COLNAMES will no longer be available.
Column does not exist and an error is returned.
Tools or applications are coded to use the obsolete COLNAMES column.
Change the tool or application to use the SYSCAT.INDEXCOLUSE view instead.