Skip to Content
1
Former Member
Nov 13, 2013 at 03:18 PM

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

68 Views

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!

Attachments

1.jpg (55.9 kB)
2.jpg (65.3 kB)