|
Problem IC67414
|
Status: Closed |
UPPER FUNCTION RETURNS SQL0171N WHEN RECORD LENGTH OF THE RECORD IS GREATER THAN THE PREVIOUS INSERTED RECORD |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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.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: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 V9.7 FP3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69454
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.03.2010
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
