Standard Features Not Supported In DB2.
Written by VR Saturday, 02 April 2011 19:18
The only aspects of SQL/89 not supported by DB2 are certain element of the Integrity Enhancement Feature, IEF.To be Specific:
- IEF supports user-defined default values.DB2 does not.
- IEF supports CHECK constraints on base tables (and column thereof).DB2 does not.
- If a primary key is single-column.IEF permits that primary key to be defined by means of a PRIMARY KEY specification within that column’s individual column definition.DB2 requires all primary keys to be defined by means of a separate PRIMARY KEY clause.
- The IEF REFERENCES specification(as part of an individual column definition) is not supported in DB2;FOREIGN KEY clause supported in DB2 only by means of a separate FOREIGN KEY clause.
- IEF permits a foreign key to reference any candidate key;DB2 requires a foreign key to reference a primary key specifically.
- DB2 does not support the REFERENCES privilege(it uses the ALTER privilege for the purpose instead).
| < Prev | Next > |
|---|