DB2 - Problembeschreibung
Problem IC96290 | Status: Geschlossen |
SQL0153N INSTEAD OF SQL0783N ERROR IS RETURNED , IF DECLARE CURSOR OF FOR STATEMENT HAS UNNAMED COLUMN. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - 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 10.1 fixpack 4. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 10.1 fix pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.09.2013 02.06.2014 02.06.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |