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