Start a new topic

DB2 LUW: Comment on view problems

Hej


I have encountered several problems with comment on views.

  • The generation of the DDL is faulty with respect to the comment on the view itself.

    image

    The correct syntax is 

    comment on table

     see comment statement

  • Even though the DDL generates a statement for the view comment, the view comment does not get displayed in the remarks field of the info tab

    image

    12.1.5 does NOT show this behaviour

    image


Beta details

Product: DbVisualizer Pro 130.3251 [BETA VERSION]
OS: Windows Server 2019
OS Version: 10.0
OS Arch: amd64
Java Version: 11.0.13
Java VM: OpenJDK 64-Bit Server VM
Java Vendor: Eclipse Adoptium
Java Home: C:\Program Files\Eclipse Foundation\jdk11
DbVis Home: D:\kellnerth\DbVisualizer_beta
User Home: C:\Users\kellnerth
PrefsDir: D:\kellnerth\git\kellnerth\.dbvis_beta
SessionId: 320
BindDir: \[3]

Varma hälsningar


Thiemo


Please ignore the latter problem. It is none, just I did not reload the object tree and reopen the object again. Maybe one might to think about a less tedious way to refresh the information in in the info tab.

The refresh button of the info tab does not work.

Thiemo,


DbVisualizer 13.0.1 has just been released with a fix for this problem.


Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade. An alternative is that you download from our website: https://www.dbvis.com/download/


Regards


Roger

Thanks Thiemo,


I will open a ticket and we'll have a look.


Regards


Roger

Login or Signup to post a comment