DB2 FOR LUW / DB2FORLUW / 970 - DB2

When executing a SQL statement that includes a % character, 
CLPPlus is not escaping these characters even when the escape 
character ('\') is placed before them. 
 
As a result, the following error is dumped: 
 
"The statement is too long or too complex. Current SQL statement 
size is #. ERRORCODE=-101, SQLSTATE=54001"

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP9                                      * 
****************************************************************

set ENVVARSUBSTITUTION OFF

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
 

Fixed in DB2 v9.7 FP9

keiner bekannt / siehe Local-Fix

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

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

03.04.2013
17.12.2013
17.12.2013

9.7.FP9