DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* DB2 V10.1                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V10.1 FP3                                         * 
****************************************************************

Declare INTEGER as the data type of the variable for ROW_COUNT

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 V10.1 FP3

Declare INTEGER as the data type of the variable for ROW_COUNT

forerunner  : APAR is sysrouted TO one or more of the following: IC89430 
follow-up : 

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

12.12.2012
17.06.2014
17.06.2014