To add columns to a C-ISAM, DISAM, or Micro Focus file entry

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

  2. Click the Table Columns tab.

    CISAM_07.jpg
     

  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.

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

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

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

  8. Maximum length is 30 characters.

Note: If you do not have a C-ISAM, DISAM, or Micro Focus database created for your Unix server or Windows system, a database is automatically created when you import. If you used the server or Windows IP address in the Server text box, the name of the new container appears as "C-ISAM", "DISAM", or "Micro Focus" followed by the IP address.

  1. Under Native Type, select a data type from the list box. See C-ISAM, DISAM, and Micro Focus Data Types. CONNX determines the SQL data type.

  2. 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.

  3. The remaining five fields display statistics related to the data: Length, Decimal Places, 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:

CONNX CDD Table Columns Tab Fields

Field

Definition

Offset

Indicates the starting point of a specific field in a table. Length = number of bytes in field.

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

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".

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 C-ISAM, DISAM, and Micro Focus file.