topic Re: Understanding RMS File Structure in Operating System - OpenVMS

Understanding RMS File Structure

Berney — Fri, 27 Oct 2006 12:26:55 GMT

hello,

I'm looking to transfer file from OpenVMS to Windows based computer.
How with an Binary file (transfered by FTP), can I reconstruct ASCII file ?
Is there any compressed record on it ?
(If I use ASCII transfert mode, I get some error (file corrupted)).
So, how can I rebuild ASCII structure from Binary one ?

What is the records separator ? How is organise an RMS file ? File Header, Records. Is records contain an Header ?

Thanks for informations.

Re: Understanding RMS File Structure

Volker Halle — Fri, 27 Oct 2006 12:40:31 GMT

Hi,

what's the File Organization ($ DIR/FULL) ?

You cannot expect to successfully transfer any non-sequential files to any non-VMS operating system.

Volker.

Re: Understanding RMS File Structure

Berney — Fri, 27 Oct 2006 12:48:24 GMT

My file is :

Size: 431136/431136 Owner: [AGD,BKA]
Created: 29-APR-1996 05:26:34.03
Revised: 27-OCT-2006 17:32:48.44 (14874)
Expires:
Backup:
Effective:
Recording:
File organization: Indexed, Prolog: 3, Using 3 keys
In 3 areas
Shelved state: Online
File attributes: Allocation: 431136, Extend: 8784, Maximum bucket size: 9
Global buffer count: 0, No version limit
Contiguous best try
Record format: Fixed length 362 byte records
Record attributes: Carriage return carriage control
RMS attributes: None
Journaling enabled: None
File protection: System:RWED, Owner:RWED, Group:RWED, World:
Access Cntrl List: None

Total of 1 file, 431136/431136 blocks.

Re: Understanding RMS File Structure

Volker Halle — Fri, 27 Oct 2006 12:54:08 GMT

AFAIK no other operating system can read OpenVMS RMS index-sequential (ISAM) files.

To transfer the data to another operating system, you need to extract the data records, i.e. convert this file to a sequential file, before trying to transfer it to another system.

If there is binary data in the record (e.g. floating point data), more work is probably required.

Volker.

Re: Understanding RMS File Structure

Berney — Fri, 27 Oct 2006 13:11:00 GMT

Thanks I'll try it :-)

Re: Understanding RMS File Structure

Hein van den Heuvel — Fri, 27 Oct 2006 14:11:50 GMT

Ah, this seems to be related to topic
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1071857

>> Understanding RMS File Structure

Start with the VMS Guide to Files.
Check the presentation I mentioned in 1071857

>> I'm looking to transfer file from OpenVMS to Windows based computer.

May we ask WHY? What do you intent to do with the (indexed) file at the windows side.
I suppose someone (me :-) could write a tool to extract records, but that's much easier done on the VMS side! There are no existing access method for RMS indexed file records on Windows best we know.

>> Is there any compressed record on it ?

Yes

>> (If I use ASCII transfert mode, I get some error (file corrupted)).

In ascii mode FTP intruct RMS to go fetch RECORDS (which may contain ascii or binary data). This makes RMS interpret the file, and (apparently) detect a corruption.

>> So, how can I rebuild ASCII structure from Binary one ?

On VMS, with CONVERT.

>> What is the records separator ?

None. Record lengths are user.

>> How is organise an RMS file ?

Records in Buckets. Prologue pointing to Index buckets, Index buckets pointing to Data buckets. Each Data bucket pointing to the locgical next bucket, as well as being pointed to from the index.

Buckets have a header (with next pointer, check bytes, free space indicator)
Records have a header (with flag, original address, data length and key compression counts)

>> Thanks for informations.

You are welcome.
Good luck!
Hein.

Re: Understanding RMS File Structure

Phil.Howell — Fri, 27 Oct 2006 17:34:46 GMT

Hein said "There are no existing access method for RMS indexed file records on Windows", however there is software available from a number of companies (connx sector7 easysoft) that provide this facility.
Phil

Re: Understanding RMS File Structure

Hein van den Heuvel — Fri, 27 Oct 2006 17:48:54 GMT

Phil, the methods you refer to are odbc/jdbc client api's and associated OpenVMS server tasks to access RMS indexed file which live on a VMS box. Attunity is an other such.

But I was referring to the actual indexed files living on windows. I believe the Sector7 products comes closest. It does RAB's and FAB's, for sequential, relative and block files, but still not RMS indexed files (they do do D-Isam).

Regards,
Hein.

http://www.sector7.com/products_and_services/openvms/vx_tools/vxrms.html

Re: Understanding RMS File Structure

term1976 — Tue, 05 Dec 2006 05:46:36 GMT

Could anyone please describe binary structure of Indexed RMS files (Prologue, Keys, etc)

Alex.

Re: Understanding RMS File Structure

Wim Van den Wyngaert — Tue, 05 Dec 2006 06:50:29 GMT

If you simply want to transfer the contents of the file in a readable format, check if you have the product datatrieve (started with the command DTR). With DTR you can define the layout of the file, select the records you want and report the fields you want. And transfer it as a sequential file.

Wim

Re: Understanding RMS File Structure

Ian Miller. — Tue, 05 Dec 2006 06:51:54 GMT

Re: Understanding RMS File Structure

Ian Miller. — Tue, 05 Dec 2006 06:54:18 GMT

There is much detail on RMS structure in

http://h71000.www7.hp.com/freeware/freeware60/rms_tools/rms_tuning.ppt

If you have a specific question then can you start a new thread as this makes it easier to find things.

See also

Re: Understanding RMS File Structure

Ian Miller. — Tue, 05 Dec 2006 06:54:27 GMT

Re: Understanding RMS File Structure

Ian Miller. — Tue, 05 Dec 2006 06:56:03 GMT

I see my previous reply arrived three times - I was having trouble accessing the forum

Re: Understanding RMS File Structure

term1976 — Tue, 05 Dec 2006 10:18:50 GMT

Hello,

thanks for reply. Presentation is very useful, but there is no information on Prologue and Areas structure.

Alex.

Re: Understanding RMS File Structure

Hein van den Heuvel — Tue, 05 Dec 2006 10:54:37 GMT

That would be because in 25 years playing with RMS indexed files I never found those interting. Just use ANAL/RMS/INT to 'see' the data or extract the defintions from LIB.MLB (or the C version) as:

$libr/extr=$areadef/out=sys$output sys$library:lib.mlb

What problem are you trying to solve?
(and as indicated, perhaps start a fresh topic for the exact problem.)

Regards,
Hein.

Re: Understanding RMS File Structure

Ian Miller. — Tue, 05 Dec 2006 11:05:50 GMT

another tool for exploring RMS indexed files is DIX
http://www.oooovms.dyndns.org/dix/

Re: Understanding RMS File Structure

term1976 — Wed, 06 Dec 2006 03:52:43 GMT

Hello,

the problem is following, I have RMS indexed file out of OpenVMS system and I need to extract information from this file for further processing.
I can parse it by myself but I need to know the structure of the file and how data is stored.

Thanks in advance,
Alex

Re: Understanding RMS File Structure

Duncan Morris — Wed, 06 Dec 2006 05:33:19 GMT

Alex,

trying to parse an RMS Indexed file on a foreign OS is like trying to reinvent the wheel!

You would get on far quicker by converting the original indexed file to a sequential file before passing it your own system.

If you need more help, please open a new topic, so that you can assign points to the relpies.

Regards,

Duncan

Re: Understanding RMS File Structure

Duncan Morris — Wed, 06 Dec 2006 05:33:35 GMT