Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Defining a Query
Database Interface Designer Reference Guide
38
Defining a Query
After you have opened an .mdq file in the Mercator Database Interface
Designer window and a database has been defined, you can specify queries. To
use a query as a source, define the query by assigning it a name and entering
either the SQL SELECT statement or the stored procedure invocation statement.
To define a query
1 In the Navigator, select Queries under the database icon ( ) for which you
want to add a query.
2 From the Query menu, select New.
The New Query dialog box appears, an example of which follows.
3 In the Name field, enter a name for your query. Use this name to reference
this query using the Map Designer or you can use it in a data source override
execution command.
4 In the Query text box, enter an SQL statement that defines how data should
be retrieved from the database.
Note If your SELECT statement includes table names with spaces, you must
enclose them with either single or double quotation marks.
5 Click OK.
The new query appears in the Navigator next to the query icon (
).