Introduction

DB2 9.7 introduces numerous features, which greatly reduce the application developer efforts, while enabling the application from a different data server to DB2. Earlier, DB2 9.5 introduced many features including implicit casting, synonym for DISCTINCT, EXCEPT, and SEQUENCES, global variables in packages, ARRAY collections, and large RID, ROWID support for fast enablement. Now in DB2 9.7, we have many more features, which can be enabled by setting the new DB2 registry variable, DB2_COMPATIBILITY_VECTOR, to a specific value, based on the need.