DB2 FOR LUW / DB2FORLUW / B10 - DB2

Once user creates table like:

db2 create table DCLGEN_TEST (c05 varchar(10) , c08
vargraphic(10)) organize by row

and execute the db2dclgn tool:

db2dclgn -d sample -t DCLGEN_TEST -l Cobol -z OS390


The output file is:

       01 DCLGEN_TEST.
         10 C05.
           49 C05-LEN PIC S9(4) COMP-5.
           49 C05-DAT PIC X(10).
         10 C08.
           49 C08-LEN PIC S9(4) COMP-5.
           49 C08-DAT PIC G(10) DISPLAY-1.


In the output above there are two problems:
- table containing underscore ( _ ) in its name is not converted
to hyphen ( - )
- The DAT keyword is specified for VARCHAR and VARGRAPHIC data
types should be TEXT


This APAR change is to correct output to expected one like
below:

       01 DCLGEN-TEST.
         10 C05.
           49 C05-LEN PIC S9(4) COMP-5.
           49 C05-TEXT PIC X(10).
         10 C08.
           49 C08-LEN PIC S9(4) COMP-5.
           49 C08-TEXT PIC G(10) DISPLAY-1.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 Version 11.1 Mod 4 Fix Pack 4 or higher       *
****************************************************************

N/A

not known / see Local fix

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

28.06.2018
23.12.2018
23.12.2018