DB2 FOR LUW / DB2FORLUW / 970 - DB2

When LIKE clause is used in a SELECT statement, and the value 
specified for the LIKE clause appears in the statement again, 
then CLPPlus is wrongly replacing this value with the dummy 
string, and hence the SQL fails. 
 
Example: 
 
SELECT * 
FROM   tab01 
WHERE  val1 LIKE 'AAA' AND 
       val2 = 'AAA' 
 
It will cause SQL0206N like this. 
SQL0206N  "CLPPLUS976LIKEHNDLMCN0070" is not valid in the 
context where it is used. 
 
Using V9.7 FP8 or earlier Fix Packs, we will not get SQL0206N, 
but the query sent to the server might be invalid.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 10                           * 
****************************************************************

Set the "environment variable substitution" off by: 
 
set envvarsubst off;

Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 10

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.04.2014
17.11.2014
17.11.2014

9.7.FP10