XML Field - Profile

Toad Data Point
1

Hi,

Is it logical or possible to profile on XML field?
Also is it possible to write select on XML data type field? I have tried xmlserializer( xml field as char) and sql editor error out.

Kindly suggest.

Regards,
Sridar

2

Are you connected Oracle or some other provider? If it is Oracle, there are several difference types of XML datatypes, binary and schema.

Go to the object explorer and view details on a table with an xmltype and look at the data tab. Can you see the xml data?

3

It’s DB2, when i look for object explorer that mean when I double click on the table, it throws error when go to data tab.

4

here is the error: when i click on data:
Capture111

5

I would suggest opening up a support case at support.quest.com so all important information can be logged and analyzed such as:

  • Are you connecting to DB2 LUW or DB2 z/OS?
  • What version of DB2? What version is your DB2 client?
  • Are you using ODBC to connect to your DB2 or are you using a DB2 cataloged connection?
  • The DDL of your table
  • ETC.