on 11-13-2013 3:18 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.