Introduction

The GENESIS RMS driver for OpenVMS uses direct RMS calls to provide very high performance with SQL access. The RMS driver supports structure tagging within RMS files to maintain legacy RMS file structures and applications.

Included with the driver is a GENESIS dictionary maintenance utility. GENESIS relies upon four dictionary tables to keep track of the RMS ISAM file layouts, including keys. The utility initializes the GENESIS dictionary. Existing RMS files are defined using an ASCII definition file.

To run the utility:

1. Create a GENESIS data source file.

In $GENESIS_HOME, create a file with

<dictsource> dkb500:[usr.rms]
<datasource> ;dkb500:[usr.rms];

where <dictsource> is a directory in which the GENESIS dictionary will be created and <datasource> is a list of directories to search for RMS files.

2. Create and load the GENESIS dictionary fr.

Assuming that the file in step 1 is called myrms,

gds8init myrms -i
gds8init myrms -alegacydef.rdf

This creates the GENESIS dictionary and also inserts the RMS structure definition contained in the legacydef.rdf file.

You are now ready to run SQL queries and updates against your existing RMS files and create new ones! You need only decide which Trifox client product to use.

How To Get GENESIS RMS

To obtain your evaluation, send an email request to info@trifox.com.

More Reading

Please refer to the GENESISsql Users Guide.

Back To Top

© 1985-2020 Updated 1 Apr 2010.