Incompatibilities.
Written by VR Saturday, 02 April 2011 19:21
- The standard and DB2 have different sets of reserved words.
- Authorization identifiers are limited to a maximum of 8 characters in DB2.
- String literals are varying length in DB2 but fixed length in the standard.
- In DB2, updates against a view V are checked against the check option specified for V and also against the check option specified for each view W on which V is defined. In other words the check option is inheritable in DB2.This is not the case with the standard.
- The DB2 concept that there is an implicit WHENEVER statement for each condition-NOT FOUND,SQLERROR also SQLWARNING at the start of the program text, specifying CONTINUE in each case is not supported in the standard.
- The standard does not explicitly permit the possible that an error on retrieval might generates a null and set the indicator variable to -2.Whether it forbids it is unclear.
- The COMMIT and ROLLBACK statements are illegal in DB2 under IMS batch,IMS/DC.
- The standard requires all concurrent executions if interleaved transactions to be serializable.DB2 cannot provide such a guarantee if any of the transactions in question executes under CS isolation level.
| Next > |
|---|