DB2 FOR LUW / DB2FORLUW / A50 - DB2

Statement returns decimal number left justified with NO leading 
zeroes on a column organized table. 
 
Operating system and level: 
All platforms with BLU tables 
 
How to reproduce the problem: 
 
Default without the knob: 
create table t1(c1 decimal(10,0) not null) 
DB20000I The SQL command completed successfully. 
 
insert into t1 values(737731) 
DB20000I The SQL command completed successfully. 
 
runstats on table mkandiah.t1 
DB20000I The RUNSTATS command completed successfully. 
 
select char(c1) as c1 from t1 
 
C1 
------------ 
737731 
 
1 record(s) selected. 
 
 
With the knob: 
db2 get db cfg | grep -i DEC_TO_CHAR_FMT 
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = V95 
 
select char(c1) as c1 from t1 
 
C1 
------------ 
737731

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fix Pack 7                               * 
****************************************************************

First Fixed in DB2 10.5 Fix Pack 7

keiner bekannt / siehe Local-Fix

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

05.01.2015
09.05.2017
09.05.2017