Possible to use a batch mainframe Cobol pgm to read an Oracle DB?greenspun.com : LUSENET : DBAzine : One Thread
I'm curious about using a batch mainframe Cobol pgm to read an Oracle DB / tables directly. We spend a lot of time writing interfaces where SQL is used in a script to create a flat file from Oracle tables. then it is FTPed to mainframe where a cobol pgm read the flat file. At a former job we used to read the DB2 tables with batch cobol pgms. we used a driver from DB2. we could plug table info into copybooks / files.
now the difference was that DB2 was mainframe version. our Oracle is running on unix. maybe a ODBC from Oracle? Does anyone do this?
Thanks in advance!
-- Deb Watson (firstname.lastname@example.org), November 20, 2003
mainframe cobol can access oracle on a pc directly. you need the oracle component TNSPROC running on the mainframe. tnsproc is a part of SQL*NET, oracle's distributed access piece.
-- steve pratt (email@example.com), August 30, 2004.