PK03323: COUNT COMMAND ON WHERE CLAUSE CONTAINING MULTIPLE CRITERIA ERRONEOUSLY RETURNS COUNT PERTAINING TO 1ST WHERE CRITERIA ONLY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When initiating a COUNT function on a specified WHERE clause
  containing multiple criteria, the COUNT returned erroneously
  reflects the number of rows qualifying for the first WHERE
  criteria only - ignoring add'l WHERE criteria.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When initiating a COUNT function on a   *
  *                      specified WHERE clause containing       *
  *                      multiple criteria, the COUNT returned   *
  *                      erroneously reflects the number of rows *
  *                      qualifying for the first WHERE          *
  *                      criteria only - ignoring add'l WHERE    *
  *                      criteria.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK03169

Modules/Macros

•    ETI@IOCT ETINAVO1 ETINAVO2 ETISRTO2
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK03169

     UP05/05/09 P F505

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.