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.

With Database/Query File	Without Database/Query File
DBLOOKUP ("`SQL_statement`", "-MDQ `mdq_file` -DBNAME `database_name`[-USER `username`] [-PASSWORD `password`] [-CCARD\|-CSTMT [`number`]] [-GTX] [-AUDIT[G][+] [`full_path`]] [{-TRACE\|-TRACEERR}[+] [`full_path`]]")	DBQUERY ("`SQL_statement`", "-DBTYPE SQLSVR -SOURCE `server`\\`database`[-USER `username`] [-PASSWORD `password`] [-CCARD\|-CSTMT [`number`]] [-GTX] [-AUDIT[G][+] [`full_path`]] [{-TRACE\|-TRACEERR}[+] [`full_path`]]")