|
I'm not entirely certain what you are asking... I'm assuming that
the customer is looking to redirect RMS system calls into an Oracle
database...
If the customer has access to the application source(s), I would
update these to use callable SQL or imbedded SQL, and write to the
database directly. I know of no way to redirect RMS calls into SQL
calls, and thus into a database. (Though that _would_ be a rather
interesting and sometimes very useful migration tool.)
Oracle (Rdb) supports its own journal files and journalling support.
The mechanisms used are the same as those used by RMS -- both are
based on the DECdtm services. But both have their own monitor and
support code, and (very likely) their own unique internal journal
file formats and journal file processing support.
As for stuffing an RMS file -- such as a journal file -- into a
database, one might be able to use the (Rdb) multi-media extensions,
or -- if this is not Rdb, whatever support the database may have for
inserting an "object" in the database. (This support allows one to
stuff an arbitrary file into a `container' in the database.) This
isn't quite what you likely want, obviously...
It is possible to combine Rdb and RMS journalling using the DECdtm
services -- one can have a single transaction across one or more
RMS files, and across one or more database files. I do not know
if non-Rdb databases make use of DECdtm, and can thus be combined
into `multi-file' transactions in this fashion. (This requires
source access.)
I would recommend against integrating the RMS journal file format
into a customer application. (This format is subject to change.)
|
|
>a database (Oracle). He is inquiring if the RMS jounalling
>product can be used for this.
I concur with the previous replies, but like to add
contrete answeres to your questions: no, no and no.
RMS Journallinglogs changed buckets with no indication
what changed in the bucket. Even if you figured out
the layout (not too hard), it would do no good as you
would not know which record changed. You'll need added
application support, calling a DBI or perhpas adding
a (key) field to a file including a change flag/timestamp.
Hein.
|