Meena_ramanathan Beginner
Joined: 25 Oct 2005 Posts: 11 Topics: 7
|
Posted: Mon Dec 08, 2008 5:08 pm Post subject: Batch SQLPLUS JCL |
|
|
Hi,
I am looking for some sample JCL which would allow me to do the following:
I have a list of telephone numbers for which I want some information from a oracle database and this job needs to be executed from a mainframe environment.
1) The first setp would take my telephone number list and create a temporary table in oracle and load it with the telephone number data
2) The second setp would execute a stored procedure in oracle and get back some information from oracle tables.
can someone help?
Thanks |
|