<div dir="ltr">DB2 version 10 onwards lets you mix SQL and XQuery commands in one query. </div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Aug 10, 2017 at 2:07 AM,  <span dir="ltr"><<a href="mailto:xquery@docbook-autor.de" target="_blank">xquery@docbook-autor.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
 Hi,<br>
<br>
I know that XQuery is typically used for transforming XML into other<br>
text file formats.<br>
<br>
But is it possible to use XQuery for the other way round?<br>
<br>
I want to transform a very simple SQL Create Table statement into XML.<br>
<br>
<br>
SQL<br>
===<br>
<br>
CREATE TABLE mytable1<br>
<br>
(<br>
  FIELD1        xxx;<br>
  FIELD2        xxx;<br>
  FIELD3        xxx;<br>
);<br>
<br>
COMMENT ON COLUMN mytable1.FIELD1 'Description1';<br>
COMMENT ON COLUMN mytable1.FIELD2 'Description2';<br>
<br>
CREATE TABLE mytable2<br>
<br>
(<br>
  FIELD1        xxx;<br>
  FIELD2        xxx;<br>
  FIELD3        xxx;<br>
);<br>
<br>
COMMENT ON COLUMN mytable2.FIELD1 'Description1';<br>
COMMENT ON COLUMN mytable2.FIELD3 'Description3';<br>
<br>
<br>
XML<br>
===<br>
<br>
<table><br>
  <title>mytable1</title><br>
  <column><br>
    <name>FIELD1</name><br>
    <comment>Description1</<wbr>comment><br>
  </column><br>
  <column><br>
    <name>FIELD2</name><br>
    <comment>Description2</<wbr>comment><br>
  </column><br>
  <column><br>
    <name>FIELD1</name><br>
    <comment></comment><br>
  </column><br>
</table><br>
<br>
<table><br>
  <title>mytable2</title><br>
  <column><br>
    <name>FIELD1</name><br>
    <comment>Description1</<wbr>comment><br>
  </column><br>
  <column><br>
    <name>FIELD2</name><br>
    <comment></comment><br>
  </column><br>
  <column><br>
    <name>FIELD1</name><br>
    <comment>Description3</<wbr>comment><br>
  </column><br>
</table><br>
<br>
Can this be done via XQuery? If not which tool could possibly fit my needs?<br>
<br>
Best regards<br>
Michael<br>
______________________________<wbr>_________________<br>
<a href="mailto:talk@x-query.com">talk@x-query.com</a><br>
<a href="http://x-query.com/mailman/listinfo/talk" rel="noreferrer" target="_blank">http://x-query.com/mailman/<wbr>listinfo/talk</a><br>
</blockquote></div><br></div>