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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||||
A fix for this issue for Campaign Management Component 7.5 is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-03-31 11:13:03 |
| Date Created: | 2003-08-11 11:31:23 |