1.
|
2.
|
To create a query, click in each column cell (Field Name, Oper., Value, And/Or), then double-click a selection from the list on the right. If the Profile option appears, you can use it to display the values in the field.
|
|
Use Field Name to indicate which field to query. You can select from the list of Available Fields, including IBM® Unica®Campaign Generated Fields. You can also create Derived Fields.
|
|
Use Oper. to select a comparison operator (for example, =, <, >, Between).
|
|
Select a Value for the field.
|
|
To add another expression, click the And/Or column, then double-click AND or OR to indicate how to combine the expressions.
|
|
To add parentheses to control evaluation order, select an expression, then use Add (...) to add a set of parentheses, Remove (...) to remove a single set of parentheses, or Clear all (...) to remove all of the parentheses in the selected expression. Parentheses allow you to group expressions when defining complex queries. For example, (AcctType = 'Gold' AND Rank = 'A') OR NewCust = 'Yes' is different from AcctType = 'Gold' AND (Rank = 'A' OR NewCust = 'Yes').
|
|
|
Select an expression then use Insert to add a blank row.
|
3.
|
Click Check Syntax to confirm whether your query syntax is valid. Checking the syntax does not put any load on the database server.
|
4.
|
5.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|