DB2 FOR LUW / DB2FORLUW / A50 - DB2

The DESCRIBE command should return length in number of
characters instead of the actual number of bytes used by the
character.  With example below each character uses 4 Bytes, thus
length shows up as 80 instead of the expected 20 characters.

create table c1(lnkey varchar(20));
create table c32(lnkey varchar(20 codeunits32));

db2 "describe table c1"
                                Data type
Column
Column name                     schema    Data type name
Length     Scale Nulls
------------------------------- --------- -------------------
---------- ----- ------
LNKEY                           SYSIBM    VARCHAR
20     0 Yes


db2 "describe table c32"
                                Data type
Column
Column name                     schema    Data type name
Length     Scale Nulls
------------------------------- --------- -------------------
---------- ----- ------
LNKEY                           SYSIBM    VARCHAR
80     0 Yes

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* This is currently a limitation                               *
****************************************************************

See LOCAL FIX.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

31.08.2016
08.05.2017
08.05.2017