Creating XML file in Informix.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SW - 30 Jan 2006 07:19 GMT

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

Reply to this Message

Martin Fuerderer - 30 Jan 2006 10:06 GMT

Hi,

this developerWorks article should have the info you
are looking for:

http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/0303cli
ne/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.
[quoted text clipped - 11 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Reply to this Message

VG - 30 Jan 2006 14:55 GMT

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/030
2roy/0302roy2.html

Reply to this Message

Art S. Kagel - 30 Jan 2006 20:08 GMT

> 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.
[quoted text clipped - 4 lines]
> Is such kind of thing exsists in Informix? Is any other option
> possible?

And to round out the replies, a plug for the IIUG Software Repository. You
can use Jonathan Leffler's sqlcmd to output XML from a SELECT.

Art S. Kagel

Reply to this Message