Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
5 replies Latest Post - ‏2012-10-01T21:07:41Z by SystemAdmin
SystemAdmin
SystemAdmin
374 Posts
ACCEPTED ANSWER

Pinned topic Physical Data Model reverse engineer skips view remark

‏2012-09-19T21:48:38Z |
Hi,

I created a physical data model from reverse engineering a DB2 9.7 DB and the comment on the view is missing in the physical data model even though it appears in syscat.tables.remarks.

The type of comment that is not appearing on reverse engineer
Example 2: Add a comment for the EMP_VIEW1 view.
COMMENT ON TABLE EMP_VIEW1
IS 'View of the EMPLOYEE table without salary information'

Strangely enough IDA is picking up the comments on individual columns within the view though.

The type of comments that are appearing on reverse engineer
Example 4: Add comments for two different columns of the EMPLOYEE table.
COMMENT ON EMPLOYEE
(WORKDEPT IS 'see DEPARTMENT table for names',
EDLEVEL IS 'highest grade level passed in school' )

How can I get IDA to pick up the view comment?
DB2 Comment on syntax for reference
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0000901.html

Thanks,
Mike
Updated on 2012-10-01T21:07:41Z at 2012-10-01T21:07:41Z by SystemAdmin
  • null
    null
    59 Posts
    ACCEPTED ANSWER

    Re: Physical Data Model reverse engineer skips view remark

    ‏2012-09-19T22:19:51Z  in response to SystemAdmin
    What's the version of IDA you are using? It works fine here. The comment of view get reverse engineering correctly.
    Can you go to Data Source Explorer --> click the view --> Property view --> Documentation tab, check if the comment
    is there or not?

    Thanks,
    -April
    • SystemAdmin
      SystemAdmin
      374 Posts
      ACCEPTED ANSWER

      Re: Physical Data Model reverse engineer skips view remark

      ‏2012-09-19T22:38:34Z  in response to null
      IDA 8.1

      I see the documentation in the Data Source Explorer.
      I don't see it in the Data Project Explorer in the Physical Data Model in my Data Development Project.

      See screenshots
      • SystemAdmin
        SystemAdmin
        374 Posts
        ACCEPTED ANSWER

        Re: Physical Data Model reverse engineer skips view remark

        ‏2012-10-01T14:23:48Z  in response to SystemAdmin
        Hi,

        Is there an open issue for this or should I open a PMR?

        Thanks,
        Mike
        • null
          null
          59 Posts
          ACCEPTED ANSWER

          Re: Physical Data Model reverse engineer skips view remark

          ‏2012-10-01T16:36:02Z  in response to SystemAdmin
          Can you try drag & drop the view with remark from Data Source Explorer to Project Explorer, go to the
          Property Browser of the view in project explorer, check if the comment get brought to the model.

          Thanks,
          -April
          • SystemAdmin
            SystemAdmin
            374 Posts
            ACCEPTED ANSWER

            Re: Physical Data Model reverse engineer skips view remark

            ‏2012-10-01T21:07:41Z  in response to null
            I don't have the original environment that I saw this problem on.
            I ran reverse engineer on a db2 9.7 FP 6 env DB and the view remark is generated now!

            Thanks,
            Mike

            I