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. Then its fairly easy to > call that stored proc from CICS and batch. > Another solution [snip] > -----Original Message----- > From: [EMAIL PROTECTED] > Sent: Mon, 16 Apr 2007 5:45 PM > > 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. 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 for Oracle to DB2 access but indicates that it can handle requests in the other direction as well. Caveat #1: the documentation reads like you *must* install Oracle on z/OS but it's just poorly done. (a common Oracle problem according to hearsay) You end up with (#DB2 regions +1) started tasks as each gateway talks to one DB2 region. (there's one 'NET' component for comms) Caveat #2: the installer expects to use XWindows but, with *lots* of aggravation, can be run with 'response' files. Again, the documentation is *grossly* incomplete. ----------> signature = 6 lines follows <-------------- Neil Duffee, Joe SysProg, U d'Ottawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uottawa.ca/ ~nduffee "How *do* you plan for something like that?" Guardian Bob, Reboot "For every action, there is an equal and opposite criticism." "Systems Programming: Guilty, until proven innocent" John Norgauer 2004 ---------------------------------------------------------------------- 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
