DB2 FOR LUW / DB2FORLUW / 970 - DB2

The following procedure will return a value of zero. Indicating 
that no rows where affected by the SELECT INTO when, in fact, a 
row was affected. 
 
 
 
create or replace procedure p1 
 
language sql 
 
dynamic result sets 1 
 
begin 
 
   declare rc int; 
 
   declare val int; 
 
 
 
   declare c1 cursor 
 
      with return to client 
 
      with hold 
 
   for 
 
      select rc 
 
        from sysibm.sysdummy1; 
 
 
 
   select 1 into val from sysibm.sysdummy1; 
 
   get diagnostics rc = row_count; 
 
 
 
   open c1; 
 
end

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 Fix Pack 4.                           * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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
 

Fixed in Version 9.7 Fix Pack 4.

not known / see Local fix

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

19.07.2010
09.05.2011
09.05.2011

9.7.FP4