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