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 stord 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 stored procedures, which are stored procedures that are written in Java but that contain SQL statements. Currently, Db2 for z/OS Developer Extension supports the ability to create, deploy, and run external Java stored procedures, but it does not support the ability to debug external Java stored procedures.

  • 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. Currently, Db2 for z/OS Developer Extension supports the ability to create, deploy, and run external SQL stored procedures, but it does not support the ability to debug external SQL stored procedures. Additionally, 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.