DB2 FOR LUW / DB2FORLUW / 970 - DB2

CREATE TYPE Rowperson AS ROW ( ID INTEGER ,FIRSTNAME VARCHAR(20) 
,LASTNAME VARCHAR(20) 
 
CREATE FUNCTION  funrow (ROWOUT Rowperson) RETURNS Rowperson 
                        BEGIN  DECLARE P Rowperson; 
                        SET P.ID = 1; 
                        SET P.FIRSTNAME = 'John'; 
                        SET P.LASTNAME = 'Doe'; 
 RETURN P; END"); 
 
In a jdbc application 
 dbmd.getFunctionColumns(null, null, "FUNROW3", null);  for a 
function  having Row Type as parameters. 
 
o/p 
 
procParmName->FUNROW3 
TYPE_NAME->ROWPERSON 
DATA_TYPE->0 
 
DATA_TYPE should be 2002 for ROW types

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of JDBC functions GETFUNCTIONCOLUMNS & GETUDTS for DB2 * 
* LUW                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP5 or newer                              * 
****************************************************************

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
 

Problem fixed in DB2 Version 9.7 Fix Pack 5

keiner bekannt / siehe Local-Fix

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

03.08.2011
07.12.2011
16.03.2012

9.7.FP5