To create a raw SQL query in the SQL Text Entry Area
1.
Enable the Select records with option in the Source tab of the Select process.
2.
Click Advanced.
The Advanced Settings window appears.
3.
Enable Use Raw SQL for Record Selection.
4.
Select the data source to query from the Database drop-down list.
5.
Select the audience to target from the Audience Level drop-down list.
6.
Click OK to close the Advanced Settings window.
7.
Click inside the SQL text entry area.
8.
Build a query by:
*
Entering raw SQL in the SQL text entry pane
*
Using the Query Helper
*
Using Point & Click
*
If you click Point & Click, you will return to building a non-SQL query expression.
9.
(Optional) Click Test Query.
*
Global suppressions and cell size limits are not applied in Test Query counts. Queries might also return non-normalized data. To obtain an accurate result count, perform a test run of the process.
10.
When you have finished building and testing your query, click OK to close the window and save your configuration.
Copyright IBM Corporation 2013. All Rights Reserved.