Data Transformation Engine Database Interface Designer Reference Guide

Chapter 7 - Database Functions Using DBLOOKUP and DBQUERY
Database Interface Designer Reference Guide
113
Using this syntax and the Syntax2 formatting issues,
DBLOOKUP and DBQUERY use
the following arguments.
Argument Explanation
SQL_statement
single_text_expression
adapter_commands
Either
-MDQ mdq_file –DBNAME db_name
or
-DBTYPE database_type
[ database_adapter_commands ]
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.
adapter_commands
Either the -MDQ or the -DBTYPE adapter command can be
used for this argument.
-MDQ
This adapter command is followed by the name of the
.mdq file produced by the Database Interface Designer.
This .mdq file contains the definition of the database
against which the SQL statement is to be executed. If the
.mdq file is in a directory other than the directory of the
map, the path must be specified.
The .mdq file name is followed by the -DBNAME adapter
command and the name of the database in the .mdq file,
as defined in the Database Interface Designer.
Note Using this syntax, the specified .mdq file must be
available at run time.