Creating an RMS Table Entry
To create an RMS table entry:
1. Click the Add button in the CONNX Data Dictionary Manager window.
2. Type the SQL Object Name.
a. Must be unique.
b. Valid CONNX table names cannot contain spaces or begin with a number.
c. Maximum length is 50 characters.
3. Select Table as the type of object to create in the Object type list box.
This option determines whether the object is a view or a table definition.
4. Select RMS as the type of database in which to create an object in the Database list box.
The option specifies the type of database in which the table is located. Valid database types for manual entry are RMS and DataFlex.
5. Click the OK button.
6. In the RMS Filename text box in the CONNX Data Dictionary Manager window, type the physical VMS path for the RMS data file.
The maximum length of the filename is 255 characters. The RMS file name may also include VAX logicals. If a logical is used in the file name, it is important that the logical is still defined when logging onto the VMS system as a network process.
7. In the Comment text box, type up to 64 characters of descriptive text.
8. In the SQL View Clause text box, you may type any valid SQL expression. This text box is used to limit the type of records returned from the table. Maximum length is 128 characters. See SQL View Clause Text Box.
Record Length is automatically pulled from the data file.
9. Select the Show CNXROWID check box to use the RFA (Record File Address) of its RMS files as the primary key.
Use this with RMS files that do not have a unique key. In RMS files, the RFA is represented by the pseudo-field CNXROWID.
10. Under Large Rotated Array Information, select Rotated Array to convert columnar arrays into rows. (See the section on Rotated Arrays.)
The Priority Count text box displays a comparison of the relative size of the tables used in join optimization. The numbers may not match the actual number of records in the RMS file. This value is automatically pulled from the data file.
Note:
If a reserved keyword is used as a field or table name in a database object, CONNX automatically appends the name with the characters _col.
If CONNX detects more than one record layout when importing, multiple data dictionary entries are created. Any RMS text import file can contain both views and tables. They do not need to be stored in separate files.