Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
62
Database Name (-DN or -DBNAME)
Use the Database Name adapter command (-DBNAME) to specify the name of a
database defined in the .mdq file that is specified using the Database/Query File
adapter command (
-MDQ). The Database Name adapter command can be used for
a source or target, or in a
DBLOOKUP, DBQUERY, GET, or PUT function.
-DBNAME
database_name
Note The database_name you supply is case-sensitive. Also, if -DBNAME is specified, it
overrides the value in the GET > Source > DatabaseQueryFile > Database
card setting.
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|SQLSVR7|SYBASE|DB2|DB2MVS|OLEDB|IFMX}
Note 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 Version 6.5 only
SQLSVR7
Microsoft SQL Server database Version 7.0 and above
SYBASE
Sybase SQL Server database
DB2
DB2 database on a Windows or UNIX platform
DB2MVS
DB2 database on an MVS platform
OLEDB
OLE DB database adapter
IFMX
Informix database adapter