| Latest versions | 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 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC69454 | Status: Closed |
UPPER FUNCTION RETURNS SQL0171N WHEN RECORD LENGTH OF THE RECORD IS GREATER THAN THE PREVIOUS INSERTED RECORD | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
| 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: "". | |
| Problem Summary: | |
****************************************************************
* 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: | |
| available fix packs: | |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux | |
| Solution | |
First fixed in V9.8 FP4 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.06.2010 04.08.2011 04.08.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.8.FP4 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.8.0.4 |
|