A fix is available
APAR status
Closed as program error.
Error description
INCORROUT FOR A CORRELATED SUBQUERY WITH MULTIPLE CCSIDS IN A CORRELATION PREDICATE . SQLSUBQUERY SQLCORRSUBQ SQLINCORROUT INCORROUT SQLINCORR SQLCCSID SQLENCODING
Local fix
Alter the query and/or tables so that the query references only a single CCSID.
Problem summary
**************************************************************** * USERS AFFECTED: DB2 for z/OS version 10 users with queries * * referencing tables with different CCSIDs. * **************************************************************** * PROBLEM DESCRIPTION: DB2 may return incorrect output for a * * query containing a subquery if a * * correlation predicate references * * multiple tables each with a different * * CCSID. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 may neglect to add a necessary cast for a correlation predicate that references tables with differing CCSIDs resulting in incorrect output. This could occur when the correlation predicate is not a direct column to column comparison. For example, SELECT T1.C1, T1.C2 FROM T1 WHERE EXISTS ( SELECT 1 FROM T2 WHERE SUBSTR(T2.C3,1,4) = T1.C2 ) If T1 and T2 are defined with different CCSIDs, a cast must be added by DB2 to predicate "SUBSTR(T2.C3,1,4) = T1.C2" to ensure the comparison is done with both sides using the same character set. DB2 could miss adding this cast in the above example leading to incorrect output. Additional Keywords: SQLINCORROUT INCORROUT SQLINCORR SQLCCSID SQLSUBQUERY SQLCORRSUBQ SQLENCODING
Problem conclusion
DB2 has been modified to correctly add the required cast and avoid the incorrect output.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM25626
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2010-11-01
Closed date
2011-01-10
Last modified date
2011-05-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK63807
Modules/Macros
DSNXOGP
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK63807
UP11/01/25 P F101
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
06 May 2011