Home > IT Answers > DataCenter > Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
Srichfdic
20 pts.
 Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
COBOL, DB2, Mainframe, Oracle, SQL, Unix
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?

Software/Hardware used:
ASKED: June 10, 2008  6:37 PM
UPDATED: September 23, 2009  4:55 PM
RELATED QUESTIONS
Answer Wiki:
the short answer is YES. the longer answer includes having TNSNAMES set properly on your mainframe and of course and DBLINKS needed and the network in place. I have worked with an application system with a similar setup. Good luck
Last Wiki Answer Submitted:  September 23, 2009  4:55 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _