Data Transformation Engine Database Interface Designer Reference Guide

Chapter 7 - Database Functions Using DBLOOKUP and DBQUERY
Database Interface Designer Reference Guide
114
Argument Description
-DBTYPE
This adapter command is followed by the type of database
(for example, ORACLE or ODBC) followed, optionally, by
database-specific adapter commands.
Note This syntax does not use an .mdq file because the
database-specific adapter commands provide the
information required to connect to the database. For
more information about your particular database
adapter and database-specific adapter commands,
refer to the adapter-specific documentation in the
adapter reference guides.
Syntax2 Formatting Issues
When using Syntax2 for DBLOOKUP or DBQUERY, your function must conform to
these rules:
♦ All adapter commands (for example,
-DBTYPE) can be either upper or lower
case, but not mixed case.
♦ A space is required between the adapter command and its value (for example,
-DT database_adapter ).
♦ The order of the adapter commands is not important.
Example 1 - Obtaining a Single Column Value
Assume that you have a table named PARTS that consists of the following data: