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]]
[-ROWCNT row_count]
[-AUDIT[G][+]
[full_path]]
[{-TRACE|-TRACEERR}[+]
[full_path]]")
|
DBQUERY ("SQL_statement",
"-DBTYPE OLEDB
-SOURCE
datalink
[-USER username]
[-PASSWORD
password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-AUDIT[G][+]
[full_path]]
[{-TRACE|-TRACEERR}[+]
[full_path]]")
|