PL/SQL (Procedural Language/Structured Query Language) statements can be compiled and executed using data server interfaces provided by Db2®. This reduces the complexity of enabling existing PL/SQL solutions to work with the Db2 data server.
The data server interfaces you can use include:
- The Db2 command line processor (CLP)
- IBM® Data Studio client
To enable this capability, set the DB2_COMPATIBILITY_VECTOR registry variable to hexadecimal 0x800 (bit position 800), then stop and restart the instance:
db2set DB2_COMPATIBILITY_VECTOR=800 db2stop db2start
To activate all compatibility features for Oracle applications, set the DB2_COMPATIBILITY_VECTOR registry variable to ORA, then stop and restart the instance:
db2set DB2_COMPATIBILITY_VECTOR=ORA db2stop db2start