Supported types of stored procedures
Stored procedures are a powerful tool for increasing the performance and efficiency of distributed applications. Db2 Developer Extension supports the following types of stored procedures:
-
Db2 for z/OS native SQL stored procedures, which are stored procedures that are written entirely in SQL and are created by using the CREATE PROCEDURE or CREATE OR REPLACE PROCEDURE statement, which is available with Db2 12 function level 507 and later.
-
External Java and SQLJ stored procedures, which are stored procedures that are written in Java or SQLJ but that contain SQL statements.
-
External SQL stored procedures, which are stored procedures that are written entirely in SQL and that contain the EXTERNAL option, the FENCED option or both. A C program and an associated package are generated for external SQL stored procedures. Note that external SQL stored procedures are deprecated in Db2 for z/OS.
Information is also provided for working with double-byte character set (DBCS) data and user-defined types.