Creating XML file in Informix.

Is there any way in Informix to create an XML File. I am trying to return the recordset returned through an Select Query into an XML File. When using an SQL server we van use "FOR XML AUTO" clause to return the resultset in XML Format. Is such kind of thing exsists in Informix? Is any other option possible? Thanks in Advance, SW

Hi, this developerWorks article should have the info you are looking for: http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/0303cline/0303cline.html This is from the abstract: Using the IBM Informix XSLT and Web DataBlades Susan Cline (clines@us.ibm.com), Software Engineer, IBM Informix Extender and DataBlade development This article presents an in-depth discussion of the Informix support for XML, including generating XML from database tables using the Web DataBlade, transforming incoming XML to XML, HTML or other text formats using the XSLT DataBlade, and using XML data as input to insert data into database tables. Examples are included. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management informix-list-bounces@iiug.org wrote on 30.01.2006 08:19:29: > Is there any way in Informix to create an XML File. I am trying to > return the recordset returned through an Select Query into an XML File. > > When using an SQL server we van use "FOR XML AUTO" clause to return the > resultset in XML Format. > > Is such kind of thing exsists in Informix? Is any other option > possible? > > Thanks in Advance, > SW > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

Check out the URL below. It shows how a simple UDR (genxml) can be used to generate XML. The source is also available for download. http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/0302roy/0302roy2.html