x
You can configure the adapters from the Web Console or the Data
Management Console. In addition, for each type of file, you must
specify the location of the data files you wish to access. You can
define the location, either by:
- Including a FILEDEF command in a supported server profile.
This approach enables you to quickly change the physical file name
associated with the metadata.
- Specifying the location when you create a synonym. This approach
enables you to define the data file location in the Master File.
x
Procedure: How to Configure the Adapters
You
can configure the adapter from either the Web Console or the Data
Management Console.
-
From the
Web Console menu bar, click Adapters.
or
From the Data Management
Console, expand the Adapters folder.
The
Adapters folder opens.
-
Expand the Available folder,
if it is not already expanded.
-
Expand the
appropriate group folder and the specific adapter folder. The group
folder is described in the connection attributes reference.
-
Right-click
the adapter name and/or version and select Configure.
The Add Adapter to Configuration pane opens.
-
Enter values
for the parameters required by the adapter, as described in the
connection attributes reference.
-
Click Configure.
The configured adapter is added to the Adapters list in the navigation
pane.
Note: The
CISAM adapters are under the Sequential and Indexed group
folder. No input parameters are required.
x
Syntax: How to Specify the Location of an AccuCobol C-ISAM File
FILEDEF file_name DISK file_location
where:
- file_name
Is the data file name.
- file_location
Is the full path and file name of the data file, without
the file extension.
Note:
- Read permissions must be given for the data file.
- For the Adapter for AccuCobol C-ISAM, read-only access is supported.
x
Syntax: How to Specify the Location of an Informix C-ISAM File
FILEDEF file_name DISK file_location
where:
- file_name
Is the data file name.
- file_location
Is the full path and file name of the data file. Omit the
.dat extension.
x
Syntax: How to Specify the Location of a Micro Focus C-ISAM File
FILEDEF file_name DISK file_location
where:
- file_name
Is the data file name.
- file_location
Is the full path and file name of the data file.
Note:
- For each data file there must be a corresponding index file,
except for Micro Focus compression 8 files, which do not have separate
index files. The index is, instead, embedded in the data file.
- Read/write permissions must be given for both types of files.
- For the Informix Adapter for C-ISAM and the Micro Focus Adapter
for C-ISAM, read and write access is supported.
x
Syntax: How to Specify the Location of a FairCom c-tree ISAM File
FILEDEF file_name DISK file_location
where:
- file_name
Is the data file name.
- file_location
Is the full path and file name of the data file, without
the file extension.
Note:
- For each data file, there must be a corresponding index file
and a corresponding parameter file.
- Read permissions must be given for all the above mentioned files.
- By default, the parameter file name is assumed to be the file_location
followed by the ".p" extension.
- You can override the default parameter file name by specifying
it in the environment variable EDACTPARMF.
- For the Adapter for FairCom c-tree ISAM, read-only access is supported.
x
Syntax: How to Specify the Location of a FairCom c-tree Parameter File
EDACTPARMF=path
export EDACTPARMF
where:
- path
Is the location of the FairCom c-tree parameter file.
Note:
- By default, the parameter file name is assumed to be the file_location
(as specified in a FILEDEF command or the DATASET attribute of a
Master File), followed by the ".p" extension.
- You can override the default parameter file name by specifying
it in the environment variable EDACTPARMF. This is required when
selecting data from multiple ISAM files in a single query through
a join. For such queries, a parameter file that describes all the tables
involved must exist, and its name must be specified in EDACTPARMF.