Hi Jim,
the easiest way is probably to write a Java Stored Procedure for DB2 on z/OS
that uses JDBC to access the Oracle DB. Then its fairly easy to call that
stored proc from CICS and batch.
Another solution could be to write a Java Class that does the JDBC to Oracle,
wrap that class with Enterprise COBOL for z/OS V3R3 or higher and call that
COBOL module from CICS or Batch (any language, just a CALL MODULE, but requires
special CEEUOPTs e.g. XPLINK(ON) and POSIX(ON)).
Just my 2 cent.
Denis.
-----Original Message-----
From: [EMAIL PROTECTED]
To: [email protected]
Sent: Mon, 16 Apr 2007 5:45 PM
Subject: DB2 for z/OS version 7 - accessing an Oracle database from CICS and
batch
Cross posted to the DB2 listserv.
Is there a way to accomplish the above. We need to be able to do a SELECT
statement from CICS and batch to an Oracle database which resides on a Unix
box.
Jim McAlpine
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
________________________________________________________________________
Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam
and email virus protection.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
