Oninit cdi / Archive
Talk to an expert →

XML Syntax

Posted in 2004

Summary

John Caron asked how to produce XML from Informix SQL. Colin Bull and Jonathan Leffler suggested the IIUG sqlcmd utility with -F XML, noting its output is only approximate XML without the header, DTD or wrapper tags. Uri Haham suggested the genxml UDR. John asked whether genxml works on IDS 7.x; no answer in the thread.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

John_Caron@mab.uscourts.gov — — source: IIUG Forums & Mailing Lists

Good afternoon all, Anyone have the syntax of a resource with the syntax to create xml data using Informix SQL ? Thanks, John

↪ replying to John_Caron@mab.uscourts.gov
Colin Bull — — source: IIUG Forums & Mailing Lists

John_Caron@mab.uscourts.gov asked > > Anyone have the syntax of a resource with the syntax to > create xml data using Informix SQL ? > sqlcmd -d DATABASE -FXML anyold.sql -- anyold.sql Select * from customer ; You will need to install the sqlcmd program if not already loaded. This available from IIUG. Colin Bull Videonetworks _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________

↪ replying to Colin Bull
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

"Colin Bull" <Colin.Bull@videonetworks.com> wrote on 12/01/2004 01:20:08 AM: > John_Caron@mab.uscourts.gov asked > > Anyone have the syntax of a resource with the syntax to > > create xml data using Informix SQL ? > > > sqlcmd -d DATABASE -FXML anyold.sql > > -- anyold.sql > Select * from customer ; Or: sqlcmd -d DATABASE -F XML -e "select * from customer" No need for trivial little files... (Also note that it is not quite strict XML output - the XML version information line, the DTD information, and the wrapper tags (eg <sqlcmd_query_result> ... </sqlcmd_query_result>) are missing. But it is a reasonable approximation to XML. Patches to improve it (SQLCMD in general, XML output in particular) are always welcomed. Thanks for the plug... -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!"

↪ replying to John_Caron@mab.uscourts.gov
Uri Haham — — source: IIUG Forums & Mailing Lists

John You can use genxml UDR. see details in the following URL http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/030 2roy/0302roy2.html regards Uri John_Caron@mab.uscourts.gov wrote: >Good afternoon all, > >Anyone have the syntax of a resource with the syntax to create xml data >using Informix SQL ? > > >Thanks, > >John > > > >*********************************************** >This Mail Was Scanned By Mail-seCure System in > Matrix Herzeliya >*********************************************** > > > >

↪ replying to John_Caron@mab.uscourts.gov
John_Caron@mab.uscourts.gov — — source: IIUG Forums & Mailing Lists

Thanks for the info Uri. Do anyone know if this works in IDS 7.x ? Thanks John H. Caron Uri Haham <uri@comsoft.co.i l> To John_Caron@mab.uscourts.gov 12/02/2004 03:46 cc PM ids@iiug.org Subject Re: XML Syntax [3812] John You can use genxml UDR. see details in the following URL http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/030 2roy/0302roy2.html regards Uri John_Caron@mab.uscourts.gov wrote: >Good afternoon all, > >Anyone have the syntax of a resource with the syntax to create xml data >using Informix SQL ? > > >Thanks, > >John > > > >*********************************************** >This Mail Was Scanned By Mail-seCure System in > Matrix Herzeliya >*********************************************** > > > >

Related threads