Mary wrote:
> I could really use some pointers. Here is the problem: I have a IBM MVS
> process that when complete will FTP a single row file to a Windows or
> AIX server. I need the data to be loaded into my Oracle DB that lives
> on an AIX server. The work has no preset time of day or day of week and
> could occur multiple times per day. I would prefer to not have a
> process wake up every 30 minutes (like a cron for example) to process
> the row. Don't want to wait as much as 29 minutes for the data to be
> handled nor do I want to run the process 48 times per day if there is
> nothing to process.
>
> I've toyed with the idea of trying to get the infrastructure in place
> that would allow me to write a program to run on the mainframe that
> would just update the AIX Oracle table directly. I think I would make
> use of the PRO*yourlanguagehere but will have to get that preprocessor
> installed as well as other systems level "stuff" to make this work.
> Seems like a lot of work and (for my shop) red tape to work thru for a
> simple update.
>
> Any other ideas would be very welcome.
>
> Thanks
If the file name is identical build an external table. Use DBMS_JOB
or DBMS_SCHEDULER to check for modification.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Feb 28 2006 - 17:06:42 CST
