DB2 FOR LUW / DB2FORLUW / 970 - DB2

The routine DBMS_SQL.IS_OPEN(cur, ret) is documented to return 
type BOOLEAN for parameter 'ret'. However, the routine 
incorrectly returns an INTEGER for ret. 
 
ret 
 
An output argument of type BOOLEAN that indicates if the 
specified file 
is open (TRUE) or closed (FALSE). 
 
 
 
db2 => select varchar(routinemodulename, 20), 
varchar(routinename, 20), 
varchar(parmname, 20), varchar(typename, 20) from 
syscat.routineparms 
where routinemodulename='DBMS_SQL' and routinename = 'IS_OPEN'; 
 
 
 
1                         2                        3 
4 
-------------------- -------------------- -------------------- 
-------------------- 
 
DBMS_SQL             IS_OPEN              C 
INTEGER 
DBMS_SQL             IS_OPEN              RET 
INTEGER 
 
This APAR fix will allow DBMS_SQL.IS_OPEN to return a value of 
type BOOLEAN, as documented.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 Fix Pack 6                               * 
****************************************************************

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
 

Problem was first fixed in Version 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84284 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.01.2012
12.07.2012
12.07.2012

9.7.FP6