RMS RU_Jounaling enabled. Datatrieve Modifiy and Write not functional.

[Jesse Grijalva]

Datatrieve Modifiy and Write procedures do not work with Journaled enabled Rms files.

Is there an update or patch to DTR to correct this ?

[Hein van den Heuvel]

[ Any Deccie's reading this? I think this was discussed in the old DTRDIG notesfile.]

jesse, I think you are correct... it is not supported.
Care to elaborate on the 'do not work'?!
Error on READY xxx WRITE?

Error message?
NRU, operation prohibited outside recovery-unit ?
DDTM_ERR, error returned by DECdtm transaction manager ?
ENV, support for RMS service call or feature not present ?

Datatrieve starts stransactions with the READY statement, but might not do a SYS$START_TRANS call. In fact, it (V7.3) indicates: DTR> HELP
COMMANDS_STATEMENTS_CLAUSES
COMMIT_Statement
:
Domains based on RMS files are not affected by the COMMIT statement.
:

I seem to recall I wrote a callable routine extension for DTR once to help support this.
To learn how to define functions for DEC DATATRIEVE, see the DEC DATATRIEVE Guide to Programming and Customizing.

I seem to recall that an other alternative is to use the calleable interface, and 'intercept' certain command to help DTR do transsaction semantics.

There is not too much data on Datatrieve on the Web I'm afraid. Best link I found is:
http://dtrwiz.home.netcom.com/
But much of that is dated/incomplete.

Anyone have online manuals?
Best place I can find for that is:
http://www.openvms-rocks.com/docs/decw$book/prodlistold.bks

Hmmm, coudl be a fun assignment to code this stuff up again!

Hope this helps some, and that the info is not too dated,

Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting

[Hein van den Heuvel]

I found some old notes (sic) back.
In 1987 DTR development folks asks RMS Engineering for details on implementing RU Journalling.

In 1994 I wrote that it still was not there.

The peak of DTR Engineering had passed at that point in time...

Hein.

[Jesse Grijalva]

No DTR (Modify and Write) support with RU_Journal enabled. Your right No Support.
Apprciate your insight.
fyi here is the DTR error message.

%RMS-F-NRU, operation prohibited outside recovery-unit

NRU, operation prohibited outside recover unit
Facility: RMS, OpenVms Record Management Services
Explanation: You rapplication program opened a data fil marked for recovey unit journaling and attempted to change the contents of the data file when no recovery unit is active.
User Action: Either unmark the data file for recovery unit journaling or put the operations that change the contents of the data file within a recovery unit.

[Richard J Maher]

Hi,

Hein, can RMS detect a "default" DECdtm transaction or does it have to be specified explicitly in some XAB thingy?

If Jesse can call sys$start_transw before the modify then would that work?

Cheers Richard Maher

PS. Can DTR even call a System Service or RTL? (Asks someone who last touched DTR about 20 years ago, but used to think it was great 'cos you could call DTR from COBOL and cross files in a collection :-)

[Hein van den Heuvel]

>> Hein, can RMS detect a "default" DECdtm transaction

Yes.

>> If Jesse can call sys$start_transw before the modify then would that work?

Yes, before the 'ready xxx [write|modify]

In my reply hinted at having done that before, using the user written functions for DTR, even pointing to the documentation for that.

Maybe I should have written more bluntly:
"For mere money I'm sure someone (pick me, pick me!) will I'll be happy to to make this available."

>> PS. Can DTR even call a System Service or RTL?

Absolutely.

Cheers,
Hein.

[Jesse Grijalva]

ok, I looked into Dtr functions. Tested a couple can't get it to work.
If you claim to have developed in the past and worked on ru_journal rms files. lets talk. I would like a proof.
regards.
JG.

[Hein van den Heuvel]

Send me an Email, or call me @603 880 8329 and we can discuss whether anything can be done here.
Regards,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting