To create a raw SQL query

Begin configuring a Select or Segment process.

For a Select process, you must switch to the Text Builder in order to write a SQL query:

Choose Select <audience> IDs With.

Change to the Text Builder (instead of the default Point & Click method).

Click Advanced.

In the Advanced Settings dialog, check Use Raw SQL for Record Selection. This option enables the use of raw SQL in the Text Builder when you specify your selection criteria. If you do not select this option, you can only use IBM® EMM expressions and Custom Macros.

Select a data source to query from the Database list. Select the target audience from the Audience Level list.

If you want to run SQL commands before or after the Select process, you can specify raw SQL in the Pre-Processing or Post-Processing area. See To specify pre- or post-processing SQL statements

Click OK to close the Advanced Settings dialog.

Enter raw SQL in the text entry area. You can use the Formula Helper to help construct the SQL. Check SQL in the Formula Helper to restrict the list of operators and functions to SQL-specific options.

For a Segment process:

Choose Segment by Query, then create or edit a segment.

Choose Select IDs With, click Text Builder, then click Advanced.

In the Advanced Settings dialog, check Use Raw SQL, select a data source, and click OK.

Enter raw SQL in the text entry area. Optionally, use the Formula Helper to help construct the SQL. Check SQL in the Formula Helper to restrict the list of operators and functions to SQL-specific options.