User`s guide

CHAPTER 5 Advanced Concepts and Tools
User’s Guide 55
From the Query window you can:
• Enter a query
• Run a query
• Save a query
• Open the Query Designer
• Look up the database schema
Entering queries
You can manually enter a SELECT statement into the Query field. You can use
any valid SQL notation of the connected database to build the query.
To open the Query Designer, click Query Designer.
To look up the database schema, click Lookup Schema.
To run the query, click Execute Query.
Note After you change an existing SELECT statement, always initialize the
component before executing another step with the component.
Validating queries
The query is immediately validated against the database system that is
connected to the component. Therefore, the query syntax must be compliant
with the native SQL dialect the connected database system is using. Using SQL
92 ANSI Standard queries allows switching to different database systems
without changing the
SELECT statements.
Query designer
The Query Designer is embedded in the Content Explorer, which is explained
in detail “Content Explorer” on page 45.
Using SBN expressions in queries
The following examples show how to use SBN expressions in queries.
Examples
A SELECT statement to retrieve a specific customer record might include a
constant customer record CU_NO for that record.