Creating SQL procedures

Creating SQL procedures is similar to creating any database object in that it consists of executing a DDL SQL statement.

SQL procedures are created by executing the CREATE PROCEDURE statement.

About this task

The CREATE PROCEDURE statement can be executed using graphical development environment tools or by directly executing the statement from the Db2® Command Line Processor (CLP), a Db2 Command Window, or another Db2 interface.

When creating SQL procedures, you can specify how the precompiler and binder should generate the procedure package, what authorization ID should be used to set the SQL procedure definer in the Db2 catalog views, and to set other package options.