|
|
|
Depending on the logic that is required, some functions are still performed on the IBM® Campaign server, even with in-database processing turned on. Some examples are given below:
|
|
All raw SQL custom macros must begin with select and contain exactly one from in the rest of the text.
|
|
For databases that only support insert into <TempTable> syntax, you must map at least one base table to the same data source at the same audience level as the raw SQL custom macro. If the fields that are selected by the raw SQL custom macro are too large for the fields of the temp table, a runtime error occurs.
|
|
If you use a raw SQL query in a Select process that has an input cell, you must use the <TempTable> token to obtain the correct list of audience IDs. Also use the <OutputTempTable> token to prevent audience IDs from being retrieved from the database back to the IBM® Campaign server.
|
Copyright IBM Corporation 2015. All Rights Reserved.
|