PL/SQL support

PL/SQL (Procedural Language/Structured Query Language) statements can be compiled and executed using data server interfaces provided by IBM® Db2® on Cloud, IBM Db2 Warehouse on Cloud, and IBM Db2 Warehouse. This reduces the complexity of enabling existing PL/SQL solutions to work with the IBM Db2 on Cloud, IBM Db2 Warehouse on Cloud, and IBM Db2 Warehouse data server.

The data server interfaces you can use include:
  • The command line processor (CLP)
  • CLPPlus
  • IBM Data Studio client

The ability to execute PL/SQL statements is enabled only if IBM Db2 on Cloud, IBM Db2 Warehouse on Cloud, and IBM Db2 Warehouse were deployed in Oracle Compatibility Mode.