RE: Table to XML file

Is there any way to get around having to specify every column by name?




-----Original Message-----
From: Birgitta Hauser [mailto:Hauser@xxxxxxxxxxxxxxx]
Sent: Friday, January 26, 2018 12:35 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: Table to XML file

Hi Justin,

the easiest way to create the XML for a Table is to use the SQL scalar Function XMLGROUP.

The following statement will return and XML-Document with the <rowset> root element and the <row> row element and the column names as elements in upper
case:
Select xmlgroup(EmployeeNo, Name, FirstName)
from lobstaff;

<rowset><row><EMPLOYEENO>20</EMPLOYEENO><NAME>Bauer</NAME><FIRSTNAME>Herrman
n</FIRSTNAME></row>

<row><EMPLOYEENO>40</EMPLOYEENO><NAME>Hauser</NAME><FIRSTNAME>Birgitta</FIRS
TNAME</row>
...
</rowset>

For returning other information such as renamed row and root elements check the XMLGROUP description.

You can also use the XML-Functions describe in the IT Jungle Article.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to." (Richard Branson)