Pl/I - Oracle or Datastage ETL

Lamrin · New User Joined: 09 Dec 2007 Posts: 2 Location: chennai

Hi,

Could we able to use oracle database or Datastage ETL tool by using PL/I code in Cobol program.

Thanks in advance for your help

Bill Woodger · Posted: Fri Mar 02, 2012 12:05 am

PL/I and Cobol are different languages. Although you can CALL PL/I programs from Cobol (and vice versa) if you put PL/I code in your Cobol program it will either not compile or, if it does compile it will be Cobol code.

Do you have any colleagues? Talk to one. Or more. Find some programs they have written. Copy them. Amend the logic to do your stuff. Etc.

Lamrin · New User Joined: 09 Dec 2007 Posts: 2 Location: chennai

Thanks for the reply,

I want to get the data from orcale database using cobol program in Z/OS.

I could see there is the way to achieve this by pro.cobol, but i would like know can we do this in Z/OS in cobol program.

Thanks

Robert Sample · Posted: Wed Mar 07, 2012 11:33 pm

Unless there is an interface between Oracle and the z/OS system, what you are asking will not be possible. If there IS an interface, then you will need to consult people AT YOUR SITE to access the documentation and find out how to use the interface. Such interfaces can be customized at each site, so what someone tells you to do based on what works at their site may very well do nothing -- or worse, break something -- at your site.