C-ISAM, DISAM, and Micro Focus Table Imports

The first line of each record layout must be as follows:

CONNXTABLE, <CONNX Table Name>, <C-ISAM, DISAM, and Micro Focus File Name>,<Record Length>, <Optional SQL Filter Clause>

Here is an example without the optional SQL filter clause:

CONNXTABLE, CustomerTable, /home/cisamfiles/customer, 64

The specifications are as follows:

CONNX Table Name - Specify a table name that will be referred to by CONNX.

C-ISAM, DISAM, and Micro Focus File Name - Refers to the physical location and name of C-ISAM, DISAM, and Micro Focus file.

Record Length - Length of the C-ISAM, DISAM, and Micro Focus record.

Optional SQL Filter Clause - Enables filtering of retrieved records.

For example, SAlesAmt > 500.00 would return only records that have a sales amount greater than $500.

Column Definition lines must be added after each table definition line, as described above. The syntax for the Column Definition lines is as follows and further defined in the table below:

<column name>	Name of the column.
<column offset>	Offset of the column. First column should always be 0.
<column type>	CHAR, INT, LONG, DOUBLE, DECIMAL are valid values.
<column scale>	Must be 0.
<column base>	Must be 0.
<column fraction>	Number of significant fractional values to show. For example, 3.333 would be 3, while 3.14165 would be 5.
<column comment>	Comments field.

Important:

When creating a C-ISAM, DISAM, and Micro Focus text file, it is recommended that you use the column scale syntax rather than the column fraction syntax.

The following is an example of a C-ISAM, DISAM, or Micro Focus text file specification for /home/cisam.txt:

CONNXTABLE, employee, /home/employee, 29
ssnum,9,0,CHAR,0,0,0
name,9,9,CHAR,0,0,0
age,2,18,INT,0,0,0
attpct,4,20,FLOAT,0,0,0
salary,4,24,LONG,0,0,0
dectype,4,28,DECIMAL,0,0,0