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) |