Interact | services | crossSessionResponse | OverridePerAudience | [AudienceLevel] | TrackingCodes | byOfferCode
The properties in this section define how cross-session response tracking matches offer codes to contact and response history.
SQL
Description
This property defines whether
Interact
uses the System Generated SQL or custom SQL defined in the
OverrideSQL
property.
Default value
Use System Generated SQL
Valid Values
Use System Generated SQL | Override SQL
OverrideSQL
Description
If you do not use the default SQL command to match the offer code to the contact and response history, enter the SQL or stored procedure here.
This value is ignored if
SQL
is set to
Use System Generated SQL
.
Default value
useStoredProcedure
Description
If set to true, the
OverrideSQL
must contain a reference to a stored procedure which matches the offer code to the contact and response history.
If set to false, the
OverrideSQL
, if used, must be an SQL query.
Default value
false
Valid Values
true | false
Type
Description
The associated TrackingCodeType defined in the
UACI_TrackingType
table in the runtime environment tables. Unless you revise the
UACI_TrackingType
table, the
Type
must be 2.
Default value
2
Valid Values
An integer defined in the
UACI_TrackingType
table.
Copyright IBM Corporation 2014. All Rights Reserved.