Support for XML as Query Output

Database

Support for XML as Query Output

Does Teradata supports generation of XML as query output like SQL Server. SQL Server has the FOR XML EXPLICIT construct which facilitate generation of XML as query output. The XML can hierarchy level depth of n. For e.g.
Suppose we have two tables Employee and Department
Employee(EmpID,Name)
Department(DeptId,DeptName)
Can I generate a XML

Can we generate a similar XML in Teradata, this is possible in SQL Server.
1 REPLY
Enthusiast

Re: Support for XML as Query Output

Hi Debasish,

I think XML publishing UDFs would help you in creating XML ouput….
Check this doc www.teradata.com/t/page/123796/index.html

Regards,
Balamurugan