Asked: Jun 10 2008 6:37 PM GMT
Asked by: Srichfdic
Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
DB2,
Oracle,
COBOL,
Mainframe,
Unix,
SQL
I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there needs to be some software from Oracle involved. Can the SELECT just be recoded with the Oracle location, or does the SELECT need to be isolated in a subroutine or as a stored procedure called by the batch COBOl program, or does it need to be coded as JDBC or some other option?
