Database Adapter Type (-DT or -DBTYPE)

Use the Database Adapter Type adapter command (-DBTYPE) to specify the database adapter type you are using. This command can be used for a source or target, or in a DBLOOKUP, DBQUERY, GET, or PUT function.

-DBTYPE {ODBC|ORACLE|SQLSVR|SYBASE|DB2|DB2MVS|OLEDB|IFMX}

The adapter type must be specified if the original card is not a database and no database is specified using the Database/Query File adapter command (-MDQ) and the Database Name adapter command (-DBNAME).

Value

Description

ODBC

ODBC database adapter

ORACLE

Oracle database adapter

SQLSVR

Microsoft SQL Server database

SYBASE

Sybase SQL Server database

DB2®

DB2 database on a Windows or UNIX platform

DB2MVS

DB2 database on an z/OS® (formerly MVS™) platform

OLEDB

OLE DB database adapter

IFMX

Informix® database adapter