SQL Procedural Language (SQL PL)

Inline SQL PL
Inline SQL PL is a subset of SQL PL features that can be used in compound SQL (inlined) statements.

SQL PL in SQL procedures
You can use SQL PL to implement procedural logic in SQL procedures.

Inline SQL functions, triggers, and compound SQL statements
Inline SQL PL statements can be executed in compound SQL (compiled) statements, compound SQL (inlined) statements, SQL functions, and triggers.

Error location in the SQLCA structure
When an error occurs during the compilation or execution of an SQL PL object, the SQLCA structure that is returned by the DB2 database manager contains information that helps in identifying the origin of the error.

SQL PL data types

SQL routines
SQL routines are routines that have logic implemented with only SQL statements, including SQL Procedural Language (SQL PL) statements.

Compound statements
A compound statement groups other statements together into an executable block. Compound statements can be executed independently or be included in the definitions of database objects such as procedures, functions, methods, and triggers. There are different SQL statements for these because there are unique differences and restrictions that apply to each.