DB2 - Problembeschreibung
Problem IT03984 | Status: Geschlossen |
WHEN LIKE CLAUSE IS USED IN SELECT STATEMENT, AND VALUE FOR LIKE CLAUSE APPEARS IN THE STATEMENT AGAIN, SQL0206N MIGHT OCCUR | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
When LIKE clause is used in a SELECT statement, and the value specified for the LIKE clause appears in the statement again, then CLPPlus is wrongly replacing this value with the dummy string, and hence the SQL fails. Example: SELECT * FROM tab01 WHERE val1 LIKE 'AAA' AND val2 = 'AAA' It will cause SQL0206N like this. SQL0206N "CLPPLUS976LIKEHNDLMCN0070" is not valid in the context where it is used. Using V10.1 FP3 or earlier Fix Packs, we will not get SQL0206N, but the query sent to the server might be invalid. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users using CLPPlus * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Customer facing this issue should upgrade to DB2 10.1 FP5 * **************************************************************** | |
Local-Fix: | |
Set the "environment variable substitution" off by: set envvarsubst off; | |
Lösung | |
This problem has been fixed in DB2 10.1 FP5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.08.2014 17.07.2015 17.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |