|
Problem IC62075
|
Status: Closed |
SQL COMPILATION FAILS WITH SQL0401N OR SQL0440N WHEN QUERY USES BUILT-IN FUNCTION WITH STRING UNIT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A query may fail to compile with SQL0401N or SQL0440N when the
query uses one of the following built-in string manipulation
functions:
SYSIBM.CHARACTER_LENGTH
SYSIBM.INSERT
SYSIBM.LCASE
SYSIBM.LEFT
SYSIBM.LENGTH
SYSIBM.LOCATE
SYSIBM.LOWER
SYSIBM.OVERLAY
SYSIBM.POSITION
SYSIBM.RIGHT
SYSIBM.SUBSTRING
SYSIBM.UCASE
SYSIBM.UPPER
The problem only occurs if one of the above string function
invocations includes the optional string unit parameter
(CODEUNITS16, CODEUNITS32 or OCTETS). For example:
select * from t1 where substring (c1, 1, 5, codeunits16) = ''
and c2=6939
SQL0401N The data types of the operands for the operation "="
are not compatible. SQLSTATE=42818
select * from t1 where c2=7453 and substring (c1, 1, 5, octets)
= ''
SQL0440N No authorized routine named "SUBSTRING" of type
"FUNCTION" having compatible arguments was found.
SQLSTATE=42884 |
| Problem Summary: |
Users Affected:
Users who are using one of the built-in string manipulation
functions.
Problem Description:
If this APAR is not applied, it is possible that a query may
fail to compile with SQL0401N or SQL0440N.
Problem Summary: See Error Description for details. |
| Local Fix: |
If possible, avoid the use of the string unit. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 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 Version 9.7, Fixpack 1 |
| Workaround |
n/a. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.07.2009
04.02.2010
04.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
