DB2 version 10 onwards lets you mix SQL and XQuery commands in one query.
On Thu, Aug 10, 2017 at 2:07 AM, 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 tra
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
(
FIELD1xxx;
FIELD2
