MVSFORUMS.com

[magesh_rathnam]

Hi all,



I want to export data from a table(selecting few columns) into a XML file. We can export data from a table into a text file with help of query like



EXPORT TO q_catlg.txt OF DEL
MODIFIED BY coldel^ chardel"" decpt. decplusblank datesiso
MESSAGES q_cat_dim.log
select * from
from <table name> tb
where tb.key = <key-value>
FOR READ ONLY;




But I want to generate a xml file containing the data from the select query. When I change the extn of the file in the query above from q_catlg.txt to q_catlg.xml, it creates a file with the same contents of the .txt file but with a extn .xml. It is not a valid xml file. Is it possible to generate a xml file from a DB2 query. Can someone help me on this.



Regards,

Magesh.

[kolusu]

magesh_rathnam,

You need to have XML extender installed to generate xml files.

Check this link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DXXXA710/CCONTENTS?DT=20010215162220

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu