Problem Note 10846: 'Invalid column name' or syntax error when using 'With any' in a
selection rule
If you create a selection rule in the SAS Campaign Management component
that contains a nested 'With any' clause, you will receive a syntax
error. The actual error received will depend on the underlying
database you are accessing. For example, with Teradata you will see:
Syntax error: expected something between '(' and ')'.
while with Oracle it will appear as:
ORA-00904: invalid column name
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.5 | 4.0 | | |
| Microsoft Windows XP Professional | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Professional | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Server | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Datacenter Server | 7.5 | 4.0 | | |
*
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: | 2003-11-19 16:24:40 |
| Date Created: | 2003-09-16 11:08:05 |
