|
Problem IC90462
|
Status: Closed |
Error SQL0171N when casting DBCLOB column into char or varchar using scalar funciton |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC90514 IC90517 IC91784
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.02.2013
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
