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