|
Problem IC63538
|
Status: Closed |
WRONG RESULTS OR ERROR SQL0802 WITH FUNCTION SYSIBM.POWER WHERE SECOND ARGUMENT IS NULL |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The result of function SYSIBM.POWER is supposed to be NULL is
any of it's input arguments is NULL.
SYSIBM.POWER will either return wrong results or error SQL0802
if the second argument is NULL.
e.g.:
db2 "values(power(10,cast(NULL as integer)))"
1
-----------
1
db2 "values(power(10,cast(NULL as decimal(5,1))))"
1
------------------------
+1.00000000000000E+140
db2 "values(power(10,cast(NULL as decimal)))"
1
------------------------
SQL0802N Arithmetic overflow or other arithmetic exception
occurred.
SQLSTATE=22003
This APAR addresses this issue and ensures correct results when
using function SYSIBM.POWER. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* The result of function SYSIBM.POWER is supposed to be NULL *
* is *
* any of it's input arguments is NULL. *
* *
* *
* *
* SYSIBM.POWER will either return wrong results or error *
* SQL0802 *
* if the second argument is NULL. *
* *
* e.g.: *
* *
* *
* *
* db2 "values(power(10,cast(NULL as integer)))" *
* *
* *
* *
* 1 *
* *
* ----------- *
* *
* 1 *
* *
* *
* *
* *
* *
* *
* *
* db2 "values(power(10,cast(NULL as decimal(5,1))))" *
* *
* *
* *
* 1 *
* *
* ------------------------ *
* *
* +1.00000000000000E+140 *
* *
* *
* *
* *
* *
* *
* *
* db2 "values(power(10,cast(NULL as decimal)))" *
* *
* *
* *
* 1 *
* *
* ------------------------ *
* *
* SQL0802N Arithmetic overflow or other arithmetic exception *
* *
* occurred. *
* *
* SQLSTATE=22003 *
* *
* *
* *
* *
* *
* This APAR addresses this issue and ensures correct results *
* when *
* using function SYSIBM.POWER. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 FP2 *
**************************************************************** |
| Local Fix: |
Use SYSFUN.POWER as a workaround. |
| available fix packs: |
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 6 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 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 9.7 FP2 (Signature: 9.7.0.2; Build level:
s100514) |
| Workaround |
Use SYSFUN.POWER as a workaround. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.10.2009
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.2,
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
