Uses

When you might want to use DBLOOKUP to execute an SQL statement:

• To retrieve a single column value from a database based upon another value in your data without the carriage return/line feed row terminator

When you might want to use DBQUERY to execute an SQL statement:

• To look up multiple column values for multiple rows in a database using a parameterized query based upon another value in your data
• When your SQL statement is a SELECT statement, the DBQUERY function can be used along with the RUN function to issue dynamic SELECT statements whose results can be used as input to a map.
• When using other SQL statements such as INSERT, UPDATE, DELETE, and so on.

For information about functions such as EXTRACT, LOOKUP, SEARCHUP, SEARCHDOWN, GET, and PUT, see the Functions and Expressions documentation.