Creating external SQL procedures (deprecated)
An external SQL procedure is a procedure whose body is written entirely in SQL. The body is written in the SQL procedural language (SQL PL). However, an external SQL procedure is created, implemented, and executed like other external stored procedures. All SQL procedures that were created prior to DB2® 9 are external SQL procedures.
Before you begin
Before you create an external SQL procedure, Configure Db2 for running stored procedures and user-defined functions during installation or Configure Db2 for running stored procedures and user-defined functions during migration.
If you plan to use the Db2 stored procedure debugger or the Unified Debugger, do not use JCL. Use DSNTPSMP instead.
If you plan to use DSNTPSMP, you must set up support for external SQL procedures.
Procedure
To create an external SQL procedure: