On 4/17/07, Neil Duffee [EMAIL PROTECTED] wrote:
At 16 Apr 2007 15:52:13 GMT, concerning re: DB2 for z/OS version 7 -
I'm gonna be sorry for suggesting it but *deep shiver up the spine*
you could also investigate Oracle's Transparent Gateway and its z/OS
component. It was just installed here
Still yet another way to do this is something called Oracle Access Manager
for CICS. (Google that and you should find some references at
oracle.com.) This is a piece of code that lets you write standard CICS
programs in just about any programming language you wish and use standard
EXEC SQL
At 16 Apr 2007 15:52:13 GMT, concerning re: DB2 for z/OS version 7 -
accessing an Oracle database from CICS and batch, Denis Gaebler
[EMAIL PROTECTED] wrote (to IBM-Main):
the easiest way is probably to write a Java Stored Procedure for DB2 on
z/OS that uses JDBC to access the Oracle DB.
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
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
On 4/16/07, Denis Gäbler [EMAIL PROTECTED] wrote:
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
Hi Jim,
I never tried it with a version earlier than V3R3, so that was the reason for
saying so. However, I am not sure from what version of COBOL on, there was no
need for OO COBOL anymore, just mixed case COBOL can be used these days, not a
COBOL class.
In addition, what came into my
Oracle has an Oracle for DRDA adapter which runs on an Oracle box and
plays with DB2's DDF; they also have an Oracle DB2 gateway which runs as
two started tasks on the mainframe: network and gateway, and makes DB2
appear to an Oracle network as another Oracle instance. I've installed the
In my previous post I mentioned the DB2 gateway - I'm not sure it works
bi-directionally; Oracle's DRDA gateway is probably what you want.
Tim Hare
Senior Systems Programmer
Florida Department of Transportation
(850) 414-4209
My memory is a bit sketchy, but in a previous life we had an Oracle Net
task running on OS/390, thus allowing you to code Oracle SQL statements
directly in Cobol. I believe such programs were also linked with an
Oracle Stub... I am not sure if this setup still exists/works today with
z/OS and do
10 matches
Mail list logo