Hi All,
I have a requirement wherein I have the following:
Program A (on one mainframe) -----CALLS---> Stored Procedure SP1 (another mainframe) using DRDA.

The Stored Procedure SP1 access some DB2 tables and gets data. But some data are stored in IDMS tables. So stored procedure needs to get data from IDMS table as well.
My question is well how to do it. Can I call a CICS transaction from within the Stored Procedure, which fetches data from IDMS and returns back to teh SP through COMMAREA? If it can be done, then would be glad if someone could please help me out.

Thanks in advance.

Try using a user-defined function.