|
Problem IC90514
|
Status: Geschlossen |
Error SQL0171N when casting DBCLOB column into char or varchar using scalar funciton |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.02.2013
16.12.2013
16.12.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP12
|
| Problem behoben lt. FixList in der Version |
