Informix XML

Posted in 2008

NADINE DIELTJENS — Tue, 22 Jul 2008 11:37:24 — source: IIUG Forums & Mailing Lists

Hi, Is it possible to extract data from informix tables into XML format ? Kind regards, Nadine

↪ replying to NADINE DIELTJENS

Obnoxio The Clown — Tue, 22 Jul 2008 11:47:05 — source: IIUG Forums & Mailing Lists

NADINE DIELTJENS said: > > Is it possible to extract data from informix tables into XML format ? It depends. What version of IDS? 11.5 is best, 11.1 is OK, previous versions could be iffy. 7.31 and before is probably right out. -- Bye now, Obnoxio http://obotheclown.blogspot.com/

↪ replying to NADINE DIELTJENS

Walter Milan — Tue, 22 Jul 2008 17:33:50 — source: IIUG Forums & Mailing Lists

Since on version 9 it is possible to generate XML using a datablade written by IBM'er Jacques Roy. It worked in our case were simples XML documents were needed, with no additional coding. This works on 10 too. Check it out. http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle /0302roy/0302roy2.html Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NADINE DIELTJENS Sent: Tuesday, July 22, 2008 6:37 AM To: ids@iiug.org Subject: Informix XML [12853] Hi, Is it possible to extract data from informix tables into XML format ? Kind regards, Nadine ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Walter Milan

Guy . — Tue, 22 Jul 2008 17:53:02 — source: IIUG Forums & Mailing Lists

Since IDS version 11 much of this functionality is built in.See: http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.x ml.doc/ids_xppublishing.html http://www.ibm.com/developerworks/blogs/page/gbowerman?tag=xml http://www.ibmdatabasemag.com/showArticle.jhtml?articleID=201201285 From IDS 11.50 there is also XSLT support. Regards Guy ----- Original Message ---- From: Walter Milan <Walter.Milan@hilton.com> To: ids@iiug.org Sent: Tuesday, July 22, 2008 10:33:51 AM Subject: RE: Informix XML [12863] Since on version 9 it is possible to generate XML using a datablade written by IBM'er Jacques Roy. It worked in our case were simples XML documents were needed, with no additional coding. This works on 10 too. Check it out. http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle /0302roy/0302roy2.html Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NADINE DIELTJENS Sent: Tuesday, July 22, 2008 6:37 AM To: ids@iiug.org Subject: Informix XML [12853] Hi, Is it possible to extract data from informix tables into XML format ? Kind regards, Nadine ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Obnoxio The Clown

Jonathan Leffler — Fri, 25 Jul 2008 20:10:07 — source: IIUG Forums & Mailing Lists

On Tue, Jul 22, 2008 at 4:47 AM, Obnoxio The Clown <obnoxio@serendipita.com> wrote: > NADINE DIELTJENS said: >> >> Is it possible to extract data from informix tables into XML format ? > > It depends. What version of IDS? 11.5 is best, 11.1 is OK, previous > versions could be iffy. 7.31 and before is probably right out. It depends on how you want the XML structured. SQLCMD has an 'XML output' mode which basically generates a structure like: <recordset> <record> <column1> ... </column1> ... </record> <record> ... </record> </recordset> You can control the tags for recordset and record by command line options; the column names are the names returned by the SELECT statement. If that's sufficient for you, then it works regardless of version of IDS. It not, then you need to look at the formal XML support available in IDS 11, for example. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.