How to Call DB2 Stored-procedure from IMS DB

This is now the capability of Zo/s. IMS batch come with a DB2 attachment facility.
Each IMS TM or batch region can be connected to only one DB2 subsystem at a time.

Steps required:

• If you want to access DB2 stored proc from IMS.You need to do DB2 pre-compile and Bind the program.
• The below stored procedure we can access it from IMS program

EXEC SQL CALL EMPRSETC(   :PDEPTNO ,:PDEPTNAME ,:PSQLCODE ,:PSQLSTATE ,:PSQLERRMC )
END-EXEC.

IMS application program must include logic to set the host variables prior to executing the CALL, and must include logic to handle any error conditions returned by the stored procedure.

Related articles

• DB2-Calling Cobol,C,Java Programs from Stored Proc (srinimf.com)
• Db2-How to Access CICS from Db2 Stored Proc? (srinimf.com)
• DB2 Stored Proc from CICS-How? (srinimf.com)