DB2 Version 9.7 for Linux, UNIX, and Windows

Compiled compound statement support has been added

Starting in Version 9.7, new compiled compound statements extend existing compound statement support by supporting more SQL PL statements and SQL language elements.

A compound statement is a BEGIN-END block that includes SQL and procedural statements. This statement is similar to an inline compound statement (previously called a SQL dynamic compound statement) except that it can contain many more SQL PL statements and language elements. A compiled compound statement provides support similar to what is supported in an SQL procedure body, but with some restrictions. Compiled compound statements can be executed within applications or interactively from the DB2 Command Line Processor, CLPPlus processor, and other supported DB2 interfaces.

The extended support for compound SQL resulted in renaming the following statements in the documentation: