cancel
Showing results for 
Search instead for 
Did you mean: 

[Reverse Engineering - IBM DB2] Column comments are being ignored

Former Member
0 Kudos

Greetings team,

When reverse engineering a DDL script file from IBM DB2 Version 9.x for z/OS e IBM DB2 Version 10 for z/OS, PowerDesigner isn't reversing column comments.

I am using PowerDesigner 16.1.

The script is being generated by DB2ADMIN  TOOL v10.2.0  (DB2 for z/OS)


Please find below a generic example of the script I am trying to reverse:

------------------------------------------------------------------------

-- Table=QSYS.TABLE1 In Q1.TABLE1

------------------------------------------------------------------------

--

CREATE TABLE QSYS.TABLE1

(C1                 CHAR(6) FOR SBCS DATA NOT NULL,

C2                CHAR(4) FOR SBCS DATA NOT NULL,

C3                 INTEGER NOT NULL,

C4               INTEGER NOT NULL WITH DEFAULT,

PRIMARY KEY (C1,

                   C2,

                   C3))

IN Q1.TABLE1

AUDIT NONE

DATA CAPTURE NONE

CCSID      EBCDIC

NOT VOLATILE

APPEND NO  ;

--

COMMENT ON TABLE QSYS.TABLE1

IS 'COMMENT 0';

--

COMMENT ON QSYS.TABLE1

(C4 IS 'COMMENT 1',

C3 IS 'COMMENT 2',

C2 IS 'COMMENT 3',

C1 IS 'COMMENT 4');

--

COMMIT;

--

Table comments are being reversed:

However, column comments are not:

Has this behavior happen to any of you? Is there a Reverse Engineering/XDB definition I must change in order to be able to reverse engineer column comments from IBM DB2?

Looking forward to hear back from you.

Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

former_member185199
Contributor
0 Kudos

Hi,

in your active model goto menue Database\Edit Current DBMS

and in the XDB editor goto

IBM DB2 Version 10 for z/OS::Script\Objects\Column\ColumnComment ( or search for "comment on column")

there you see as Value:

comment on column [%QUALIFIER%]%TABLE%.%COLUMN% is

%.q254:COMMENT%

there are no "(" ")" in this definition maybee this is your problem?

can you try if he imports :

COMMENT ON QSYS.TABLE1  C4 IS 'COMMENT 1';

COMMENT ON QSYS.TABLE1  C3 IS 'COMMENT 2';

COMMENT ON QSYS.TABLE1  C2 IS 'COMMENT 3';

I hope this  helps you

cheers

dj

Answers (0)