Supported types of procedures

IBM Db2 Developer Extension provides comprehensive support for working with procedures in your Db2 databases.

Native SQL procedures

IBM Db2 Developer Extension currently supports native SQL procedures. These procedures are written entirely in SQL and created by using the CREATE PROCEDURE or CREATE OR REPLACE PROCEDURE statement.

Key characteristics

The key characteristics of the native SQL procedures are:

• Run directly within the Db2 database engine.
• Require no external programs or languages.
• Provide optimal performance for database operations.
• Support SQL control statements (IF, WHILE, FOR, and so on).
• Include multiple SQL statements in a single procedure.
• Support input (IN), output (OUT), and input/output (INOUT) parameters.