Data Transformation Engine Database Interface Designer Reference Guide

Chapter 7 - Database Functions Using DBLOOKUP and DBQUERY
Database Interface Designer Reference Guide
112
The following table describes these arguments in more detail.
Argument Description
SQL_statement
SQL statement as a text string. It can be any valid SQL
statement permitted by your database management system
and supported by your database-specific driver.
In addition to a fixed SQL statement, this argument can be
a concatenation of text literals and data objects, enabling
the concatenation of data values into your SQL statement.
mdq_file
Name of a database/query file (.mdq) produced by the
Database Interface Designer. It contains the definition of
the database against which the SQL SELECT statement is to
be executed. If the .mdq file is in a directory other than the
directory of the map, the complete path must be specified.
Note The .mdq file is accessed at map build time and is
not needed at runtime.
database_name
Name of a database in the .mdq file as defined in the
Database Interface Designer.
Note This name is case-sensitive and must exactly match
the name as defined in the Database Interface
Designer.
Syntax2 - Using Dynamic Adapter Commands
Use Syntax2 to execute a SELECT statement that retrieves a specific column value
from a table or database when the database, table, or other database parameters
may vary. This can be used when parameters are being supplied by a parameter
file.
DBLOOKUP(
SQL_statement,adapter_commands )
DBQUERY(
SQL_statement,adapter_commands )