DBLOOKUP or DBQUERY functions

The DBLOOKUP and DBQUERY functions can be used in component rules in the schema 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 IFMX 
  -SOURCE datalink 
[-USER username]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]'')