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