Identifying a Data Source Type: SUFFIX

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.

Syntax: How to Identify a Data Source Type

SUFFIX = data_source_type

where:

data_source_type

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.

Example: Specifying the Type for a FOCUS 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

Reference: SUFFIX Values

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