Hi
I am trying to convert data in to XML using SQL. I converted data to XML but struggling to add subgroup in XML.
It will be great help if someone can help.
Exec SQL
Select XmlDocument
(xmlgroup(TDTABL as "TABL",
KEYF as "KEYF",
DESC as "DESC",
TABL as "STRU"
Option Row "TABLE"
Root "TEST"))
into :XMLDoc
From SYdd ;
e.g.
<TABLE>
<TABL>NOHDSH</TABL>
<KEYF>29 </KEYF>
<DESC>FREIGHT CHARGES(/DESC><STRU>NOHDSH</STRU>
</TABLE>
But I want to make it as
<TABLE>
<TABL>NOHDSH</TABL>
<KEYF>29 </KEYF>
<DESC>FREIGHT CHARGES(/DESC>
<STRU>
<STRU1>NOHDSH</STRU1>
</STRU>
<STRU>
<STRU1>NOHDSH1</STRU1>
</STRU>
</TABLE>
I am trying to convert data in to XML using SQL. I converted data to XML but struggling to add subgroup in XML.
It will be great help if someone can help.
Exec SQL
Select XmlDocument
(xmlgroup(TDTABL as "TABL",
KEYF as "KEYF",
DESC as "DESC",
TABL as "STRU"
Option Row "TABLE"
Root "TEST"))
into :XMLDoc
From SYdd ;
e.g.
<TABLE>
<TABL>NOHDSH</TABL>
<KEYF>29 </KEYF>
<DESC>FREIGHT CHARGES(/DESC><STRU>NOHDSH</STRU>
</TABLE>
But I want to make it as
<TABLE>
<TABL>NOHDSH</TABL>
<KEYF>29 </KEYF>
<DESC>FREIGHT CHARGES(/DESC>
<STRU>
<STRU1>NOHDSH</STRU1>
</STRU>
<STRU>
<STRU1>NOHDSH1</STRU1>
</STRU>
</TABLE>
Comment