How to display XML data from XML data field in CLP each tag into own line

grofaty · #1 (**permalink**) 02-19-09, 09:09

Hi,
in DB2 v9.5 I have table with XML data field. When I execute "select * from table" statement to display XML data from DB2 CLP I get one line output:

Code:

<employees><employee id="1"><name>Mark</name><office>IBM</office></employee><employee id="2"...

I would like to get output each tag into own row something like bellow:

Code:

<employees>
<employee id="1">
<name>Mark</name>
<office>IBM</office>
</employee>

in DB2 CLP, just to see contents of XML in human readable way. How?
Regards

stolze · #2 (**permalink**) 02-19-09, 09:56

You could use the REPLACE function to replace all substrings "></" with ">\n</".

What I am typically doing is to write the XML document into a file and view this in a browser. That gives me folding capabilities for larger documents.

grofaty · #3 (**permalink**) 02-20-09, 02:15

I have found one solution instead of "select" I used xquery:
db2-fn:xmlcolumn('schema.table.column')

Internet Services

Web Development

Digital Marketing

Consumer Tech