Configuring the C-ISAM and ISAM Adapters

How to:

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:

Procedure: How to Configure an Adapter

  1. From the Web Console sidebar, click Connect to Data.

    or

    From the Data Management Console, expand the Adapters folder.

    In the DMC, the Adapters folder opens. In the Web Console, the Adapters page opens showing your configured adapters.

  2. In the Web Console, click the New Datasource button on the menu bar and find the adapter on the drop-down list or, in the DMC, expand the Available folder if it is not already expanded.
    On the Web Console, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.
  3. In the DMC, expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Right-click the adapter name and/or version and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Enter values for the parameters required by the adapter, as described in the chapter for the specific adapter you want to configure.
  6. Click Configure. The configured adapter is added to the Adapters list in the DMC resources tree or the Configured list in the Web Console.
    In the Web Console, the adapter remains on the Available Adapters list with a check mark to indicate that at least one connection has been configured. You can configure additional connections from either the Configured or Available list by right-clicking the adapter and clicking Add Connection.

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.

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.

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.

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.

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.

WebFOCUS

Feedback