SQL Compatibility

Introduction
If you have Oracle's PL/SQL knowledge and want to reuse it on DB2 for Linux Unix and Windows you need to set up DB2 database with Oracle compatibility mode so that DB2 can understand PL/SQL syntax. You can control which of the compatibility features are enabled using specific settings of the DB2_COMPATIBILITY_VECTOR registry variable. This registry variable is represented as a hexadecimal value, and each bit in the variable enables one of the DB2 compatibility features. Set value ORA to enable all the supported compatibility features.