|
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 Data does not support the following suffixes: BWBAPI, COMT, DBASE, FPA, SQLSAP, SOAP, TABT, XML, and XFOCUS.
SUFFIX = data_source_type
where:
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 |
|
ALLBASE/SQL |
SQLALB or ALLBASE |
|
CA-Datacom/DB |
DATACOM |
|
CA-IDMS/DB |
IDMSR |
|
CA-IDMS/SQL |
SQLIDMS |
|
C-ISAM |
C-ISAM |
|
DB2 |
DB2 or SQLDS |
|
DB2/2 |
SQLDBM |
|
DB2/400 |
SQL400 (SQL access) DBFILE (native access) |
|
DB2/6000 |
DB2 |
|
DBMS |
DBMS |
|
DMS |
VSAM (keyed access) FIX (non-keyed access) |
|
Digital Standard MUMPS |
DSM |
|
Enscribe |
ENSC |
|
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 |
|
Image/SQL |
IMAGE |
|
IMS |
IMS |
|
INFOAccess |
SQLIAX |
|
Information/Management |
INFOMAN |
|
Informix |
SQLINF |
|
Ingres |
SQLING |
|
KSAM |
KSAM |
|
Micronetics Standard MUMPS |
MSM |
|
Model 204 |
M204IN |
|
Native Interface |
SQLSAP |
|
NETISAM |
C-ISAM |
|
NOMAD |
NMDIN |
|
NonStop SQL |
NSSQL |
|
Nucleus |
SQLNUC |
|
ODBC |
SQLODBC |
|
OpenIngres |
SQLING |
|
Open M/SQL |
SQLMSQ |
|
Oracle |
SQLORA |
|
PACE |
VSAM |
|
Progress |
SQLPRO |
|
Rdb |
SQLRDB |
|
Red Brick |
SQLRED |
|
RMS |
RMS |
|
SQL/DS |
SQLDS |
|
SQL Server |
SQLMSS |
|
StorHouse |
SQLSTH |
|
Sybase |
SQLSYB |
|
Tab Delimited |
TABT, TAB |
|
Teradata |
SQLDBC |
|
Token Delimited |
DFIX |
|
TurboIMAGE |
IMAGE OMNIDEX (using OMNIDEX IMS indices) |
|
Unify |
SQLUNIFY |
|
uniVerse |
UNIVERSE |
|
VSAM |
VSAM PRIVATE (for FOCSAM user exit) |
|
Non-standard data source |
Name of the customized data access routine |