DBLOOKUP and 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.

Using DBLOOKUP with a database/query file

DBLOOKUP ("SQL_statement",
"-MDQ mdq_file
 -DBNAME database_name
[-USER username]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]")

Using DBQUERY without a database/query file

DBQUERY ("SQL_statement",
"-DBTYPE ODBC
[-SOURCE datasource]
[-USER username]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]")