DB2 FOR LUW / DB2FORLUW / B50 - DB2

This issue is with named ET where the external table column
definition is created based on base table.

create table base(c1 int, c2 CHAR(1 OCTETS) NOT NULL IMPLICITLY
HIDDEN WITH DEFAULT 'A')
create external table et1 sameas base using (dataobject
'/home/ngupta4k/test/data.del')
db2 describe table et1

                                Data type
Column
Column name                     schema    Data type name
Length     Scale Nulls
------------------------------- --------- -------------------
---------- ----- ------
C1                              SYSIBM    INTEGER
4     0 Yes
C2                              SYSIBM    CHARACTER
1     0 No

  2 record(s) selected.

If user wants to go back to original behaviour of INCLUDING
hidden columns in SAMEAS/LIKE syntax, then set the regvar:

db2set -im DB2_EXTBL_INCLUDE_HIDDEN_COLS=YES

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5.5.0 or higher                            *
****************************************************************

not known / see Local fix

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

30.07.2020
20.11.2020
20.11.2020