|
Problem IC90517
|
Status: Closed |
Error SQL0171N when casting DBCLOB column into char or varchar using scalar funciton |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 v10 fixPack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.02.2013
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
