Here. https://www.ibm.com/developerworks/data/library/techarticle/dm-1006queriespurexml/index.html
On Thu, Aug 10, 2017 at 2:13 AM, Ihe Onwuka <ihe.onw...@gmail.com> wrote: > DB2 version 10 onwards lets you mix SQL and XQuery commands in one query. > > On Thu, Aug 10, 2017 at 2:07 AM, <xqu...@docbook-autor.de> wrote: > >> >> Hi, >> >> I know that XQuery is typically used for transforming XML into other >> text file formats. >> >> But is it possible to use XQuery for the other way round? >> >> I want to transform a very simple SQL Create Table statement into XML. >> >> >> SQL >> === >> >> CREATE TABLE mytable1 >> >> ( >> FIELD1 xxx; >> FIELD2 xxx; >> FIELD3 xxx; >> ); >> >> COMMENT ON COLUMN mytable1.FIELD1 'Description1'; >> COMMENT ON COLUMN mytable1.FIELD2 'Description2'; >> >> CREATE TABLE mytable2 >> >> ( >> FIELD1 xxx; >> FIELD2 xxx; >> FIELD3 xxx; >> ); >> >> COMMENT ON COLUMN mytable2.FIELD1 'Description1'; >> COMMENT ON COLUMN mytable2.FIELD3 'Description3'; >> >> >> XML >> === >> >> <table> >> <title>mytable1</title> >> <column> >> <name>FIELD1</name> >> <comment>Description1</comment> >> </column> >> <column> >> <name>FIELD2</name> >> <comment>Description2</comment> >> </column> >> <column> >> <name>FIELD1</name> >> <comment></comment> >> </column> >> </table> >> >> <table> >> <title>mytable2</title> >> <column> >> <name>FIELD1</name> >> <comment>Description1</comment> >> </column> >> <column> >> <name>FIELD2</name> >> <comment></comment> >> </column> >> <column> >> <name>FIELD1</name> >> <comment>Description3</comment> >> </column> >> </table> >> >> Can this be done via XQuery? If not which tool could possibly fit my >> needs? >> >> Best regards >> Michael >> _______________________________________________ >> talk@x-query.com >> http://x-query.com/mailman/listinfo/talk >> > >
_______________________________________________ talk@x-query.com http://x-query.com/mailman/listinfo/talk