CICS® IAuses 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.
CICS IA supports
both Native and External SQL Stored Procedures. Native Stored Procedures
are only supported in DB2 V9.1
or above. For more information about available stored procedures,
see CICS IA External Interfaces.
External 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 hlq.SCIUSAMP.DB2(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 for z/OS Administration Guide.