CICS® IA V3.2 uses DB2® Stored Procedures to perform complex DB2 tasks.
A stored procedure is an executable code that can be called by other programs. You might choose to use stored procedures for the code that is used repeatedly. Other benefits of stored procedures include network traffic reduction, result sets returned directly to an application, or access to data without granting the privileges to the applications.
DB2 Stored Procedures run in a started task called WLM (Work Load Manager) associated with each DB2 subsystem. Sample JCL for a stored procedure can be found in SCIUSMP1(CIUSPTSK). The name of the started task must match the one supplied in the CICS IA configuration variable _wlm_.
You can find more information about implementing DB2 Stored Procedures in the DB2 Version x.1 for z/OS® Administration Guide.
The DB2 Stored Procedures used by CICS IA are of the type External SQL Stored Procedures. For details about available stored procedures, see CICS IA External Interfaces.