DB2 FOR LUW / DB2FORLUW / 970 - 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 V9.7                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP9                                      * 
****************************************************************

Declare INTEGER as the data type of the variable for ROW_COUNT

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
 

First fixed in DB2 V9.7 FP9

not known / see Local fix

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

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

09.01.2013
17.12.2013
17.12.2013

9.7.FP9