Developing SQL Stored Procedures

DB2 implements SQL stored procedures as external C programs. The DB2 precompiler can take an SQL procedure as input and write out a C source module. An SQL procedure is created by using one of the following three methods: DB2 Development Center stored procedure, directly invoking DSNTPSMP, or using JCL or CLIST to prepare.

When an SQL procedure is built using the DB2 Development Center, all the "code" is developed on the client workstation, and the completed procedure is passed to the DSNTPSMP stored procedure. DSNTPSMP is the z/OS SQL Procedure Processor, a REXX-stored procedure, and it is also fully customizable. This processor invokes the following steps:

1.	SQL precompile
2.	C precompile
3.	C compile
4.	Prelink
5.	Link
6.	Procedure definition
7.	Bind

Once the procedure is built in this fashion, it is immediately executable. When using the other two methods for developing an SQL procedure, they bypass the DB2 Development Center and either directly invoke DSNTPSMP or execute these steps under manual control.