To add columns to an RMS file

  1. Select the table to which columns will be added in the CONNX Data Dictionary Manager window.

  2. Click the Table Columns tab.

    image6.gif
     

  3. Click the Add Column button. The cursor moves to a new row in the table.

  4. Under SQL Column, type the name of the new column.

  1. A valid column name must be unique within the table.

  2. The CONNX column name may be different from the SQL column name. Rename columns or use alias column names.

  3. Valid column names cannot contain spaces or begin with numbers.

  4. Maximum length is 30 characters.

  5. Under Native Type, select a data type from the list box. CONNX determines the SQL data type.

  6. Click the Calc Offsets button to automatically enter the offset value in the Offsets column. Do not use the Calc Offsets button if your record contains redefined fields.

  7. The remaining five fields display statistics related to the data: Length, Precision, Scale, Array Offset, and Comment. The data in these fields can be modified, depending on the data type. A description of each field is included in the following table:

Field

Definition

Length

Physical length in bytes of the column.

Precision

Number of implied decimal places.

Scale

Number of places to move the decimal point in a numeric field. A scale of +2 will convert the number 345.67 to 3.4567, and a scale of -2 will convert the number 345.67 to 34567.

Array Offset

Used to determine the size of one element of an array when used with the Rotated Array Option. Refer to "Using the Rotated Array Assistant (RMS and VSAM only)" on page 3-18 of the CONNX Security and Administration Guide for more information.

Comment

Used to provide up to 64 characters of descriptive text.

  1. Click the Tables Indexes tab, and then click the Refresh Indexes button to refresh the indexes defined for the .dat RMS file.

    Note:     If you do not have an RMS database created for your server, a database is automatically created when you import. The new container has the same name as your server. If you used the server IP address in the Server text box, the name of the new container appears as "RMS_" followed by the IP address.