home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList
9.7.0.9 FixList