|
Problem IC90517
|
Status: Geschlossen |
Error SQL0171N when casting DBCLOB column into char or varchar using scalar funciton |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 v10 fixPack 3 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.02.2013
01.04.2013
01.04.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
