|
Problem IC67414
|
Status: Geschlossen |
UPPER FUNCTION RETURNS SQL0171N WHEN RECORD LENGTH OF THE RECORD IS GREATER THAN THE PREVIOUS INSERTED RECORD |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - 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.7 FP2 *
****************************************************************
* 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.7 FP3 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 V9.7 FP3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69454
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 24.03.2010
24.09.2010
24.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
