Understanding RMS File Structure

[Berney]

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.

[Volker Halle]

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.

[Berney]

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.

[Volker Halle]

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.

[Berney]

Thanks I'll try it :-)

[Hein van den Heuvel]

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.

[Phil.Howell]

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

[Hein van den Heuvel]

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

[term1976]

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

Alex.

[Wim Van den Wyngaert]

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