C-ISAM, DISAM, and Micro Focus Table Imports

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

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

 

Note: The optional SQL Filter Clause is not used in this example.

 

Example:

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

 

 

CONNX Table Name

User can 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.

 

Example:

SalesAmt > 500.00

Only records that have a sales amount greater than $500. are retrieved.

 

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:

 
C-ISAM, DISAM, and Micro Focus Column Specification

<column name>, <column length>, <column offset>, <column type>, <column scale>, <column base>, <column fraction>, <column comment>

 
C-ISAM, DISAM, and Micro Focus Text File Import Syntax and Description

Syntax

<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