|
Problem IC64427
|
Status: Geschlossen |
STRING VALUE IN STORED PROCEDURE RESULT SET HAS EXTRA SPACE WHEN DISPLAYED FROM DB2 CLP |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
When calling a stored procedure from the DB2 CLP, a string value
in the result set displays one more extra space.
For example, if a column in the result set is defined as
VARCHAR(255), the value displayed to the screen will be the
string value padded by extra spaces up to a length of 256.
There should only be padded spaces up to a length of 255. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Could occur on v95 and later releases. All platforms, *
* easilyreproducible. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When calling a stored procedure from the DB2 CLP, a *
* stringvaluein the result set displays one more extra *
* space.For example, if a column in the result set is defined *
* asVARCHAR(255), the value displayed to the screen will *
* bethestring value padded by extra spaces up to a length of *
* 256.There should only be padded spaces up to a length of *
* 255. *
****************************************************************
* RECOMMENDATION: *
* upgrade to db2_v95fp6 or db2_v97fp2 or later releases. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
db2_v95fp6 contains the fix of this issue, as a result the user
will get padded spaces up to a length of 255. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC64443
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.11.2009
30.06.2010
30.06.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
