DB2 FOR LUW / DB2FORLUW / A10 - 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 v10.1 Fix Pack 1 or higher                        * 
****************************************************************

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 10.1 Fix Pack 1

keiner bekannt / siehe Local-Fix

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

13.06.2012
31.12.2012
31.12.2012