|
Problem IC63916
|
Status: Closed |
CAST OF A GRAPHIC OR VARGRAPHIC EXPRESSION TO A NUMERIC TYPE MAY OUTPUT SQL0420N (SQLCODE -420) |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
A graphic or vargraphic expression used as input to the CAST
function which outputs a numeric type may lead to an
SQL0420N (SQLCODE -420).
This can occur if numeric type is any of SMALLINT, INTEGER,
BIGINT or DECIMAL. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* A graphic or vargraphic expression used as input to the CAST *
* function which outputs a numeric type may lead to an *
* SQL0420N (SQLCODE -420). *
* *
* *
* *
* This can occur if numeric type is any of SMALLINT, INTEGER, *
* BIGINT or DECIMAL. *
****************************************************************
* RECOMMENDATION: *
* None *
**************************************************************** |
| Local Fix: |
Use the synonym [SMALLINT, INTEGER, BIGINT,
DECIMAL](<var/graphic-expression>) functions instead of the
CAST function. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Problem was first fixed in Version 9.1 FP9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.10.2009
16.04.2010
16.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
