DB2 Version 9.7 for Linux, UNIX, and Windows

PL/SQL language is supported by DB2 interfaces

In DB2® Version 9.7, PL/SQL can be compiled and executed using DB2 interfaces.

DB2 Version 9.7 supports the compilation of the PL/SQL language. This support for PL/SQL compilation can be enabled by setting or updating the DB2_COMPATIBILITY_VECTOR registry variable.

Porting existing PL/SQL scripts, package definitions, or individual PL/SQL and SQL statements that work with other database management systems to DB2 Version 9.7 is done by executing them from a DB2 Command Window or from the DB2 Command Line Processor.

With the DB2 environment initialized for PL/SQL, the DB2 compiler processes the PL/SQL DDL statements and creates the required database objects in the database. PL/SQL anonymous blocks, as well as references to commonly used package routines and views can also be compiled and executed.

In Version 9.7 Fix Pack 1 and later fix packs, FORALL syntax and BULK COLLECT INTO syntax are supported in the DB2 PL/SQL compiler:

The FORALL statement supports the INSERT, searched DELETE, searched UPDATE, and EXECUTE IMMEDIATE statements. Logically, a FORALL operation iterates over an array, processing the data change for each array element as a block operation.
The BULK COLLECT extension to the INTO clause (in the SELECT INTO, FETCH, and EXECUTE IMMEDIATE statements) uses arrays to store multiple rows of data (either scalar types or records).

With this support, you quickly enable PL/SQL solutions in DB2 environments.