To pass multiple commands in a raw SQL statement
You can pass multiple commands in a raw SQL statement.
If your database allows multiple commands to be passed, you can enter as many valid SQL commands as you need, with the following rules:
Commands are separated with the appropriate delimiter;
The last command must be a select command;
This select command must select all the relevant fields required in defining your audience level in the same order the audience level is defined;
No other select statements are used.
1.
Enable the
Select records with
option in the Source tab of the Select process.
2.
Click
Advanced
.
The Advanced Settings window appears.
3.
Click to enable
Use Raw SQL
.
This activates raw SQL, a feature that passes your exact query syntax to the database.
4.
Select the database to use and the desired audience level.
Click
OK
.
5.
Enter your SQL commands in the
Select records with
text box.
Click
OK
.
Copyright IBM Corporation 2013. All Rights Reserved.