Fix (APAR):                IZ66813

Status:                    Fix

Product:                   WBI

Release:                   6.2.0.2

Operating System:          All operating systems

Supersedes Fixes:          

Pre-requisite Fixes:       

Exclusive-requisite Fixes: 

CMVC Defect:               IZ66813

Byte size of APAR:         59319

Date:                      2010-01-13

Abstract:                  Query Table API: primary query table conditions for composite query tables with OR-conditions might result in incorrect results.

Description/symptom of problem:

If you specify a filter condition with an OR operator for the primary query table in a composite query table 
the results might be incorrect. During internal processing an additional condition might be appended 
with an AND operator which leads to an incorrect SQL query.
If the filter condition was specified with surrounding brackets ( ... OR ... ), the results are correct.


NOTE: Update installer version 7.0.0.1 or later is required to install this interim fix.

NOTE: This interim fix is applicable to a full WPS installation only, and should not be applied to a WPS client installation.

Directions to apply fix:

1) Copy pak file to the directory maintenance in the UpdateInstaller directory

2) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

3) Follow the Fix installation instructions that are packaged with the Fix Installer on how to install the Fix.

4) Restart WebSphere


Directions to remove fix:
NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS
       ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be
          removed, fix3 must be removed first, then fix2 may be removed

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix.

3) Restart WebSphere

Directions to re-apply fix:

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix.

3) Restart WebSphere


Additional Information: