DB2 - Problembeschreibung
Problem IC91274 | Status: Geschlossen |
DB2CAEM RETURNS SQL0104 WHEN SQL HAS SINGLE QUOTE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
This APAR is a duplicate of IC91770 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.04.2013 08.10.2013 08.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |