JCL to interact with Oracle DB

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
Posts: 1
Joined: Thu Oct 22, 2015 1:24 pm
Location: Bangalore

JCL to interact with Oracle DB

Post by akj22102015 » Thu Oct 22, 2015 1:38 pm


We currently have a few SQR's which run on mainframe that update tables on DB2(using JCL via IKJEFT01).

As part of changes these SQR 's will need to update Oracle DB that resides on a remote server. The SQR 's will continue to run on mainframe and will have no interaction with DB2.

Could you please reference any guides / manuals which could help me out with JCL changes in this regard.

Also please let me know if any middleware is required to achieve the same.

Thanks for your help!!!



Topic deleted by Admin

Post by academyindia4 » Tue Jan 19, 2016 7:20 pm

<< Content deleted By Admin >>

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others