Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

If you create a prioritization in the SAS Campaign Management component
that includes a filter, you may receive an error similar to the
following:

  Error Number: 40002
   Line Number: 0
     Component: Campaign Management Component
        Module: MCommon
     Procedure: BuildView
   Description: 42601: [IBM][CLI Driver][DB2] SQL0104N  An unexpected
                token "," was found following "".  Expected tokens may
                include: "* <IDENTIFIER> ". SQLSTATE=42601.

This error may occur because the source and destination tables ('record
to map from' and 'record to map to') as defined in the 'Define Filters'
screen, do not have unique keys.  If you use filters you are required to
have unique keys in both the source and destination tables.  To correct
the problem, ensure that unique keys are defined in both tables in the
database, and that you have specified those key values in the KEYFLD and
KEYDEFN fields in the ISMDBSTR table.


A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html

If you apply this hotfix, the Campaign Management application no longer
allows you to define a filter using tables that do not have unique keys
associated, and thereby prevents the error from occurring.

Operating System and Release Information

A fix for this issue for Campaign Management Component 7.5 is available at: