DB2 FOR LUW / DB2FORLUW / 970 - DB2

When db2caem is ran with SQL that has single quote, it returns 
error as below: 
 
 
SQL: 
select * from t2 where col1 <> '3' 
 
db2caem -d sample -st "select * from t2 where col1 <> '3'" 
 
Error: 
DBT7028E  "db2caem": The db2caem command failed because the DB2 
database manager 
 encountered an error while processing the specified input 
parameters and the sp 
ecified SQL statement. Handle type: "3". Return code: "-1:2162". 
           CLIInfo: SQLstate: "42601" 
                    Return code: "-104" 
                    Diagnostic message: "[IBM][CLI 
Driver][DB2/AIX64] SQL0104N 
An unexpected token "3" was found following "m t2 where col1 <> 
'".  Expected to 
kens may include:  "CONCAT".  SQLSTATE=42601

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 db2caem tool users                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix pack 8                        * 
****************************************************************

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
 

Problem first fixed in DB2 Version 9.7 Fix pack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC88551 IC88554 IC91274 IC91770 
follow-up : 

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

26.11.2012
08.04.2013
08.04.2013

9.7.FP8