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

Mary wrote:
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@x.washington.edu
(replace x with u to respond)

"Mary" <mary.steelman (AT) gmail (DOT) com> 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
:

what version of oracle? what file format?

you should be able to ftp the file directly into the database's XDB
repository, and (theoretically) have that trigger the necessary database
processing -- fairly simple to do if the file can be in XML format

++ mcs