DB2 - Problembeschreibung
Problem IC70839 | Status: Geschlossen |
CIE00760 PROTOCOL ERROR HAPPENS IN DYNAMIC SQL STATEMENTS involving temp table and text search. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
CIE760 protocol error happens with the dynamic sql like: "WITH TEMPTABLE(jobid, testcase, score) AS (SELECT jobid, testcase, SCORE(RUNFILE, CAST(? AS VARCHAR(30)))*100 FROM testresults) SELECT * FROM TEMPTABLE WHERE score > 0 ORDER BY score ASC"; if replace host variable with the search keyword and make sql statement as static, the problem wont happen. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * This CIE760 protocol error only happens with the dynamic sql * * like: * * * * "WITH TEMPTABLE(jobid, testcase, score) * * * * AS (SELECT jobid, testcase, SCORE(RUNFILE, CAST(? AS * * * * VARCHAR(30)))*100 FROM testresults) * * * * SELECT * FROM TEMPTABLE WHERE score > 0 ORDER BY score * * ASC"; * * if replace ? with the search keyword and make sql statement * * as static, * * the problem wont happen. * * SELECT jobid, testcase, SCORE(RUNFILE, CAST(? AS * * * * VARCHAR(30)))*100 FROM testresults would run fine. * **************************************************************** * RECOMMENDATION: * * No. * **************************************************************** | |
Local-Fix: | |
replace host variable with the search keyword and make sql statement as static | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in V97fp3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.08.2010 31.08.2010 31.08.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |