Problem Note 9482: 'Error whilst counting selection rule criteria' when using a dynamic
calculated column with a DB2 database running on MVS
If you use the SAS Campaign Management component with a DB2 database
running in an IBM mainframe MVS environment, and you attempt to use a
dynamic calculated column in a selection rule, you will receive the
following message:
Error whilst counting selection rule criteria.
Reported as Error -204:
S0002: [IBM][CLI Driver][DB2] SQL0204N "SUKXXX.HLD485FV" is an
undefined name. SQLSTATE=42704
This problem does not occur with any other databases. There is no known
workaround.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Campaign Management | Microsoft Windows XP Professional | 7.4 | 7.5 |
| Microsoft Windows 2000 Professional | 7.4 | 7.5 |
| Microsoft Windows 2000 Server | 7.4 | 7.5 |
| Microsoft Windows 2000 Advanced Server | 7.4 | 7.5 |
| Microsoft Windows NT Workstation | 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-07-15 09:37:43 |
| Date Created: | 2003-02-24 12:16:24 |