Start a new topic

Presentation of XML Columns (DB2) like clobs

[This topic is migrated from our old forums. The original author name has been removed]

Hi, I am using DBVis with a DB2 database, and there are some columns defined as XML (data_type = 1111, type_name=XML). Currently it's displayed like a varchar which result in a very very very long column of text, and this not really friendly. I suggest to display it like clobs (puzzle piece, requires to double click to display the content in another window) Is it possible ? Kind Regards, Yvesdm.
1 Comment

[This reply is migrated from our old forums.]

Re: Presentation of XML Columns (DB2) like clobs
Hi, What you can do is to limit the number of characters displayed in a grid. Do this in Tools->Tool Properties and in the General / Grid category. "Max Column Width" is the setting I am referring too. It is currently not possible handle the XML data type as the puzzle piece types (Binary/BLOB and CLOB). Regards Roger