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 IC96354 Status: Geschlossen

GET DIAGNOSTICS RETURNS SQL0401N WHEN ROW_COUNT VARIABLE IS DECLARED AS
DECIMAL

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
CREATE PROCEDURE statement returns SQL0401N when it contains GET 
DIAGNOSTICS statement where ROW_COUNT variable type is decimal, 
which is the documented data type. 
 
CREATE PROCEDURE sqlprocg (IN deptnbr VARCHAR(3)) 
   LANGUAGE SQL 
   BEGIN 
      DECLARE SQLSTATE CHAR(5); 
      DECLARE rcount DECIMAL(31,0); 
      UPDATE PROJECT 
         SET PRSTAFF = PRSTAFF + 1.5 
         WHERE DEPTNO = deptnbr; 
      GET DIAGNOSTICS rcount = ROW_COUNT; 
   END 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0401N  The data types of the operands for the operation "GET" 
are not 
compatible or comparable.  LINE NUMBER=9.  SQLSTATE=42818
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4 or later.             * 
****************************************************************
Local-Fix:
Declare INTEGER as the data type of the variable for ROW_COUNT
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 10.5 Fix Pack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.09.2013
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList