DB2 - Problembeschreibung
Problem IC89531 | Status: Geschlossen |
SQL0153N INSTEAD OF SQL0783N ERROR IS RETURNED , IF DECLARE CURSOR OF FOR STATEMENT HAS UNNAMED COLUMN. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
SQL0153N instead of SQL0783N error was returned , if FOR statement has unnamed column. CREATE OR REPLACE PROCEDURE "DB2INST1"."TEST1" ( MSG IN OUT VARCHAR2 ) IS v_msg VARCHAR2(30); BEGIN FOR cur_test in (SELECT 1 FROM DUAL) LOOP v_msg := 'HELLO'; END LOOP; END Test1; DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0153N The statement does not include a required column list. LINE NUMBER=8. SQLSTATE=42908 However, SQL0153N error is incorrect. SQL0783N is correct error number. A duplicate column name or unnamed column was specified in a DECLARE CURSOR statement of a FOR statement. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 UDB version 9.7 fixpack 9. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95665 IC96290 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.01.2013 23.12.2013 23.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |