DB2 FOR LUW / DB2FORLUW / A50 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4 or later.             * 
****************************************************************

Declare INTEGER as the data type of the variable for ROW_COUNT

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
 

First fixed in DB2 Version 10.5 Fix Pack 4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.09.2013
08.09.2014
08.09.2014