Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    São Paulo - Brazil

    Question Unanswered: HELP! - Call DB2 STORED PROCEDURE mainfraime from Oracle

    I work with DB2 MVS/TSO (mainfraime) and Oracle (Unix).
    I need to do a procedure in PL/SQL or OAS to acess a stored procedure in DB2 -mainfraime.

    How can I do this????????

    A version of DB2 is v7, and oracle 8i.

    Célia Regina
    Information Technology & e-Business Infrastructure
    Database Administration and End-User Support

  2. #2
    Join Date
    Mar 2003
    I'm also looking into this at the moment. In fact posted here but no answers. To the best of my limited knowledge, it would seem that to call a stored procedure on the mainframe from Oracle, you would need additional software ibn the form of Oracle Transparent Gateway for IBM DRDA .

    There is an alternative way to connect to DB2 from Oracle called Generic Connectivity which uses ODBC. This is part of the base product so no extra cost, but it does not allow you to call stored procs.

    If you find out any more please let me know...

Posting Permissions

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