|
View previous topic :: View next topic
|
| Author |
Message |
vaddi.ajay
New User
Joined: 20 May 2007
Posts: 1
Location: Chennai
|
|
|
|
We have an oracle database residing on a Unix server (REGPAR). On mainframe, we have a job running every 15 minutes, that needs to get data from the oracle database.
so is it possible to retrieve the data from Unix server on Mainframes. If so, how can this be done? |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
One way to get the data from Oracle to the mainframe is to run a process on the unix system that pulls data from Oracle and ftps the results to the mainframe. The mainframe job would process the uploaded data and delete the file after making a copy (unless none was needed). |
|
| Back to top |
|
|
diwa_thilak
Active User
.jpg)
Joined: 13 Jul 2006
Posts: 205
Location: At my desk
|
|
|
|
Just add one more view , similar to dick's view.
1. We too had the similar requirement. We had the data uploaded to Mainframe Queue and our job will take care of draining the messages from the Queue.
2. In the second scenario as dick suggested, Oracle needs to FTP the file to Mainframes, Once th file is ready, we can have Mainframe trigger job to trigger the mainframe job to run with the existing file.
Hope i made clear to you.
Thanks,
Diwakar
----------------------------------------
Nobody is Perfect. I am Nobody |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| I, too, would be interested in knowing how or if this can be done. Our shop is setup similar to the way the O/P described. |
|
| Back to top |
|
|
|
|
