|
Problem IT06300
|
Status: Closed |
STATEMENT RETURNS DECIMAL NUMBER LEFT JUSTIFIED WITH NO LEADING ZEROES ON A COLUMN ORGANIZED TABLE WITH DEC_TO_CHAR_FMT=V95 |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 10.5 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First Fixed in DB2 10.5 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.01.2015
09.05.2017
09.05.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
