PL/SQL anonymous blocks in DB2 9.7


IBM DB2 9.7 for Linux, UNIX and Windows introduces support for PL/SQL anonymous blocks: a feature that enables PL/SQL application developers to test, troubleshoot, and prototype new procedural code, simulate application runs, and dynamically build complex ad-hoc queries and reports.

This article describes the concept of anonymous blocks in DB2 9.7 and illustrates the use of this feature using common database scenarios.