Problem Note 10430: Syntax error occurs when running selection rules with calculated columns
If you run a selection rule in the SAS Campaign Management component
that references the same calculated column in both the field and the
value parts of a comparison, the application generates incorrect SQL.
This causes syntax errors to occur.
For example, if you submit the following rule:
Select Client Where Client Age CC dyn = {Client Age CC dyn}
you will receive an error message similar to the following:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: MDoCounts
Procedure: sServerMakeView
Description: 37000:[NCR][Teradata RDBMS] Syntax error:expected
something between '=' and')'.
Note that the Description portion of the error text varies based on the
ODBC driver being used.
To circumvent the problem, avoid using the same calculated column
reference on both sides of the same comparison operator.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.4 | 7.5 |
| Microsoft Windows XP Professional | 7.4 | 7.5 |
| Microsoft Windows 2000 Professional | 7.4 | 7.5 |
| Microsoft Windows 2000 Advanced Server | 7.4 | 7.5 |
| Microsoft Windows 2000 Server | 7.4 | 7.5 |
| Microsoft Windows 2000 Datacenter Server | 7.4 | 7.5 |
*
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: | medium |
| Date Modified: | 2003-07-30 09:06:28 |
| Date Created: | 2003-07-17 10:52:06 |
