How can I run a SAS program in mainframe that calls Oracle in Unix
Hi,
I need to run my SAS program in z/OS which call Oracle in Unix to retreive data from Oracle table.
I tried this SAS program in PC SAS without any problem.
How do I connect to Oracle in my SAS prgram in z/OS?
Need help, please
Software/Hardware used:
Unix, SAS, z/OS, Oracle
I need to run my SAS program in z/OS which call Oracle in Unix to retreive data from Oracle table.
I tried this SAS program in PC SAS without any problem.
How do I connect to Oracle in my SAS prgram in z/OS?
Need help, please
Software/Hardware used:
Unix, SAS, z/OS, Oracle
ASKED:
August 12, 2010 7:12 PM
UPDATED:
August 13, 2010 2:37 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
You will need some sort of communication between your z/OS program and Oracle on AIX.
Won’t you need SQLNET (TNS) on z/OS and AIX to handle to communication?