|
Problem IC63916
|
Status: Geschlossen |
CAST OF A GRAPHIC OR VARGRAPHIC EXPRESSION TO A NUMERIC TYPE MAY OUTPUT SQL0420N (SQLCODE -420) |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in Version 9.1 FP9 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.10.2009
16.04.2010
16.04.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
