DBLOOKUP or DBQUERY functions

The DBLOOKUP and DBQUERY functions can be used in component rules in the Type Designer and map rules in the Map Designer when creating a map that can be used with a database without specifying a database/query file name (.mdq) or a database name.

Using DBLOOKUP with a database/query file:

DBLOOKUP 
(''SQL_statement'',
''-MDQ DDNAME 
-DBNAME database_name
[-CCARD|-CSTMT [number]]
[{-TRACE [file|ERROR]}]'')

Using DBQUERY without a database/query file:

DBQUERY 
(''SQL_statement'', 
''-DBTYPE ODBC
[-SOURCE datasource]
[-CCARD|-CSTMT [number]]
[{-TRACE [file|ERROR]}]'')