DB2 FOR LUW / DB2FORLUW / 970 - DB2

DECFLOAT_FORMAT and VARCHAR_FORMAT functions with a numeric 
first 
argument may fail or return unexpected results if there are 
leading 
blanks in the input arguments. 
 
Sample scenarios where wrong behavior may be encountered : 
 
DECFLOAT_FORMAT with format string having more than 5 leading 
blanks returns SQL20476N instead of the value. 
 
VARCHAR_FORMAT with format string having more than 5 leading 
blanks returns SQL20476N  instead of the value 
 
VARCHAR_FORMAT with all blanks  in the format-string may return 
unexpected result instead of expected SQL20476N 
 
DECFLOAT_FORMAT with more than 4 leading blanks in input string 
returns SQL20477N instead of the value.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of VARCHAR and DECFLOAT_FORMAT functions               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* INCORRECT HANDLING OF LEADING BLANKS IN ARGUMENTS OF         * 
* DECFLOAT_FORMAT AND VARCHAR_FORMAT FOR DECFLOAT TO VARCHAR   * 
* SCENARIO                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install 97FP4 or later which contain the fix, or eliminate   * 
* leading blanks from input arguments to VARCHAR_FORMAT and    * 
* DECFLOAT_FORMAT functions                                    * 
****************************************************************

Strip leading blanks from input arguments before passing them in 
to DECFLOAT and VARCHAR_FORMAT functions.

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
 

Install 97FP4 or later which contain the fix, or eliminate 
leading blanks from input arguments to VARCHAR_FORMAT and 
DECFLOAT_FORMAT functions

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC73587 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

29.12.2010
28.04.2011
28.04.2011

9.7.FP4