Problem Note 10637: Syntax error occurs when running a selection rule with multiple INCLUDE,
EXCLUDE, or OVERLAP sets
If you run a selection rule in the SAS® Campaign Management component
that references multiple INCLUDE, EXCLUDE, or OVERLAP sets, you might
receive the following error:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: MCommon
Procedure: BuildVolatileTable
Description: 37000: [NCR][Teradata RDBMS] Syntax error: expected
something between the 'UNION' keyword and '('.
This error only occurs if the underlying database is Teradata, and you
do not have the UseMinus configuration option set.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.4 | | | |
| Microsoft Windows XP Professional | 7.4 | | | |
| Microsoft Windows 2000 Professional | 7.4 | | | |
| Microsoft Windows 2000 Advanced Server | 7.4 | | | |
| Microsoft Windows 2000 Server | 7.4 | | | |
| Microsoft Windows 2000 Datacenter Server | 7.4 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-03-31 11:13:03 |
| Date Created: | 2003-08-11 11:31:23 |
