Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC91274 Status: Closed

DB2CAEM RETURNS SQL0104 WHEN SQL HAS SINGLE QUOTE

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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
Problem Summary:
Local Fix:
Solution
Workaround
not known / see Local fix
Comment
This APAR is a duplicate of IC91770
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.04.2013
08.10.2013
08.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)