Adding Columns to a C-ISAM, DISAM, or Micro Focus File Entry

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

1. Select a table in the CONNX Data Dictionary Manager window.

2. Click the Table Columns tab.

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.

The name must be unique within the table.

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

The name must not begin with a number or contain spaces.

Maximum length is 30 characters.

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.

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. If necessary, modify the remaining five fields that display statistics related to the data.

A description of each field is included in the following table:

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.

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