PK87963: SELECT/COMPARE FAILS TO UPDATE COLUMN IF SOURCE OR TARGET VALUE IS NULL

APAR status

• Closed as program error.

Error description

• Update Detection method SELECT/COMPARE fails to update a record
  if the column being updated contains NULL in either the source
  or target .
  
  e.g. if the column being updated contains NULL in the target
  table and a value 4 in the source table the target will not be
  updated with the value 4.
  The same is true if the source value is NULL and the target
  value is 4. The column will not be updated with the NULL value.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI DATA MG

• Fixed component ID

  5724W12DM

Applicable component levels