Problem Note 10440: Syntax error when saving a campaign that contains a calculated user
defined field
If you try to save a campaign in the SAS Campaign Management component
that contains a calculated user defined field, and your underlying
database is Teradata, you may receive the following error:
Error Number: 40002
Line Number: 0
Component: Campaign Management Component
Module: CCampaign
Procedure: SaveToShadowColumns
Description: 37000: [NCR][Teradata RDBMS] Syntax error: expected
something between '=' and ','.
The error occurs when the format of the field contains the percent sign
character ('%'). In these cases, the '%' is not stripped off when the
value is passed to the SQL code generator, resulting in an invalid
numeric value and the generation of incorrect SQL code.
Operating System and Release Information
| 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: | high |
| Date Modified: | 2003-08-04 11:13:43 |
| Date Created: | 2003-07-17 17:16:54 |
