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
User can specify a table name that will be referred to by CONNX.
Refers to the physical location and name of C-ISAM, DISAM, and Micro Focus file.
Length of the C-ISAM, DISAM, and Micro Focus record.
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:
<column name>, <column length>, <column offset>, <column type>, <column scale>, <column base>, <column fraction>, <column comment>
|
Syntax |
Description |
|---|---|
|
<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