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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!