DB2 - Problem description
Problem IT20009 | Status: Closed |
"CLP SELECT STATEMENT DISPLAY FIX FOR CHAR AND VARCHAR CODEUNITS32 STRING UNITS" | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Fix the display of select statement for char and varchar codeunits32 string_units. Prior to this fix, clp would display the codeunits32 column with a header of actual number of characters * 4 bytes With this fix, clp would display the codeunits32 column with a header of actual number of characters*2 bytes. e.g: before the fix: db2 "create table codeunits32_table(c1 char(2 codeunits32 ), c2 varchar(2 codeunits32))" db2 "insert into codeunits32_table values('aa','bb')" db2 "select * from codeunits32_table" C1 C2 -------- -------- aa bb 1 record(s) selected. after fix: C1 C2 ---- ---- aa bb 1 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 CLP * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to V10.5 FP9 and later * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
Fixed in V10.5 FP9 and later | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.04.2017 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |