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 not know what the cost is for running Oracle Net (I would assume it isn't free!).
Greg -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Jim McAlpine Sent: Monday, April 16, 2007 11:45 AM To: [email protected] 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 ---------------------------------------------------------------------- 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
