SQL Procedural Language

The DB2 SQL Procedural Language (SQL PL) is used in DB2 to develop stored procedures. It’s an subset of the SQL Persistent Stored Modules (SQL/PSM) standard.

SQL PL has an very simple syntax and is quit useful for database administrators and developers to create stored procedures. Multiple SQL PL statements are available to create business logics in the procedures.

Furthermore Inline SQL PL (an subset of SQL PL) can be used for triggers, user defined functions, and compound statements.


Link to the DB2 Information Center: DB2 9.7 DB2 10.1 DB2 10.5