| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC69454 | Status: Geschlossen |
UPPER FUNCTION RETURNS SQL0171N WHEN RECORD LENGTH OF THE RECORD IS GREATER THAN THE PREVIOUS INSERTED RECORD | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
| Problembeschreibung: | |
Upper function returns SQL0171N when record length of the record
is greater than the previous inserted record
SQL0171N The data type, length or value of the argument for the
parameter in
position "3" of routine "SYSIBM.UCASE" is incorrect. Parameter
name: "".
SQLSTATE=42815
db2 "create table tb (col1 varchar(20))"
DB20000I The SQL command completed successfully.
db2 "insert into tb values('a')"
DB20000I The SQL command completed successfully.
db2 "insert into tb values('aa')"
DB20000I The SQL command completed successfully.
C:\Documents and Settings\Administrator>db2 "select
upper(col1,'en_US',CODEUNITS16) from tb"
1
------------------------------------------------------------
A
SQL0171N The data type, length or value of the argument for the
parameter in
position "3" of routine "SYSIBM.UCASE" is incorrect. Parameter
name: "". | |
| Problem-Zusammenfassung: | |
****************************************************************
* USERS AFFECTED: *
* DB2 V9.8 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Upper function returns SQL0171N when record length of the *
* record *
* is greater than the previous inserted record *
* *
* *
* *
* SQL0171N The data type, length or value of the argument for *
* the *
* parameter in *
* *
* position "3" of routine "SYSIBM.UCASE" is incorrect. *
* Parameter *
* name: "". *
* *
* SQLSTATE=42815 *
* *
* *
* *
* db2 "create table tb (col1 varchar(20))" *
* *
* DB20000I The SQL command completed successfully. *
* *
* *
* *
* db2 "insert into tb values('a')" *
* *
* DB20000I The SQL command completed successfully. *
* *
* *
* *
* db2 "insert into tb values('aa')" *
* *
* DB20000I The SQL command completed successfully. *
* *
* *
* *
* C:\Documents and Settings\Administrator>db2 "select *
* *
* upper(col1,'en_US',CODEUNITS16) from tb" *
* *
* *
* *
* 1 *
* *
* ------------------------------------------------------------ *
* *
* A *
* *
* SQL0171N The data type, length or value of the argument for *
* the *
* parameter in *
* *
* position "3" of routine "SYSIBM.UCASE" is incorrect. *
* Parameter *
* name: "". *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.8 FP4 *
**************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux | |
| Lösung | |
First fixed in V9.8 FP4 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.06.2010 04.08.2011 04.08.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.8.FP4 | |
| Problem behoben lt. FixList in der Version | |
| 9.8.0.4 |
|