DB2 FOR LUW / DB2FORLUW / 970 - DB2

When selecting a dbclob column into a char a SQL0171N error is 
produced. 
 
db2 "create table tab1(col1 dbclob(1 g)) not logged initially" 
DB20000I  The SQL command completed successfully. 
 
db2 "select char(col1) from tab1" 
SQL0171N  The data type, length or value of the argument for the 
parameter in 
position "2" of routine "SYSIBM.CHAR" is incorrect. Parameter 
name: "". 
SQLSTATE=42815

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users casting large CLOB data to CHAR or VARCHAR types.      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW version v9.7 fixPack 8                    * 
****************************************************************

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
 

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC90514 IC90517 IC91784 
Nachfolger : 

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

25.02.2013
01.04.2013
01.04.2013

9.7.FP8