How to: Reference: |
The SUFFIX attribute identifies the type of data source you are using. For example, a DB2 data source or a FOCUS data source. Based on the value of SUFFIX, the appropriate data adapter is used to access the data source.
The SUFFIX attribute is required for most types of data sources. It is optional for a fixed-format sequential data source. However, if you refer to a fixed-format sequential data source in a JOIN command, then the SUFFIX attribute must be declared in the Master File.
Note: Maintain does not support the following suffixes: COMT, TABT, and XFOCUS.
You can create your own data access module for any non-standard data source that cannot be described using a standard Master File. In this case you would assign the name of the data access module to the SUFFIX attribute in the Master File.
SUFFIX = data_source_typewhere:
Indicates the type of data source or the name of a customized data access module. The default value is FIX, which represents a fixed-format sequential data source.
The following example specifies the data source type FOC, representing a FOCUS data source which has 4K database pages:
SUFFIX = FOC
The following example specifies the data source type XFOCUS, representing an XFOCUS data source which has 16K database pages:
SUFFIX = XFOCUS
The following table indicates the SUFFIX value for many of the supported data source types:
|
Data Source Type |
SUFFIX Value |
|---|---|
|
ADABAS |
ADBSIN or ADBSINX ADABAS (OpenVMS EDA 2.x and FOCUS 6.x) |
|
CA-Datacom/DB |
DATACOM |
|
CA-IDMS/DB |
IDMSR |
|
CA-IDMS/SQL |
SQLIDMS |
|
DB2 |
DB2 or SQLDS |
|
Fixed-format sequential |
FIX This value is the default. PRIVATE (for FOCSAM user exit) |
|
FOCUS |
FOC |
|
Free-format (also known as comma-delimited) sequential |
COM, COMMA, COMT |
|
IMS |
IMS |
|
MODEL 204 |
M204IN |
|
NOMAD |
NMDIN |
|
Oracle |
SQLORA |
|
SQL/DS |
SQLDS |
|
Tab-Delimited |
TABT, TAB |
|
Teradata |
SQLDBC |
|
Token-Delimited |
DFIX |
|
VSAM |
VSAM PRIVATE (for FOCSAM user exit) |
|
XFOCUS |
XFOCUS |
|
Non-standard data source |
Name of the customized data access routine. |
| Information Builders |