DB2 FOR LUW / DB2FORLUW / 970 - DB2

When a database is created with UCA500R1 collating sequence, and 
a query similar to the following is issued, a. SQL0130N error is 
returned, 
 
$ db2 "select * from tab1 where x like null" 
 
SQL0130N  The ESCAPE clause is not a single character, or the 
pattern string contains an invalid occurrence of the escape 
character. 
SQLSTATE=22025

**************************************************************** 
* USERS AFFECTED:                                              * 
* v97fp5                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V97fp6                                            * 
****************************************************************

Use "IS NULL" predicate instead of "LIKE NULL"

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84226 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.12.2011
12.06.2012
12.06.2012

9.7.FP6