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