Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Accessing IDMS from Stored procedure

    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.

  2. #2
    Join Date
    Aug 2004
    Try using a user-defined function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts