PL/SQL support

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)
  • CLPPlus
  • IBM® Data Studio client

Enablement

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