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]]") |