|
Problem IC74270
|
Status: Geschlossen |
DB2 MIGHT NOT RETURN EXPECTED RESULTS FOR SCALE FUNCTIONS WITH SMALLINT INPUT. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2 might return an error message or incorrect results when
scale function (LEFT, RIGHT, OVERLAY, INSERT) are used with
SMALLINT as inputs.
For example, although correct, following query might return
error code SQL0138N:
SELECT LEFT('002', SMALLINT(2)) FROM SYSIBM.SYSDUMMY1
SQL0138N A numeric argument of a built-in string function is
out of range.
SQLSTATE=22011 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All the user of DB2 v9.7 FP3 and earlier. *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 might return an error message or incorrect results when *
* *
* scale function (LEFT, RIGHT, OVERLAY, INSERT) are used with *
* *
* SMALLINT as inputs. *
* *
* *
* *
* For example, although correct, following query might return *
* *
* error code SQL0138N: *
* *
* *
* *
* SELECT LEFT('002', SMALLINT(2)) FROM SYSIBM.SYSDUMMY1 *
* *
* *
* *
* SQL0138N A numeric argument of a built-in string function *
* is *
* out of range. *
* *
* SQLSTATE=22011 *
****************************************************************
* RECOMMENDATION: *
* Explicitly cast the small int as integer. *
* *
* *
* eg. db2 "SELECT LEFT('002', cast(SMALLINT(2) as integer)) *
* FROM *
* SYSIBM.SYSDUMMY1"; *
* *
* Also consider upgrade to DB2 v9.7 FP4. *
**************************************************************** |
| Local-Fix: |
Explicitly cast the small int as integer.
eg. db2 "SELECT LEFT('002', cast(SMALLINT(2) as integer)) FROM
SYSIBM.SYSDUMMY1"; |
| verfügbare FixPacks: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem was fixed in DB2 v9.7 FP4. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC74272
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.02.2011
28.04.2011
28.04.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
