Convert MS SQL 'for xml path()' to Teradata syntax.

Database

Convert MS SQL 'for xml path()' to Teradata syntax.

I have a query in MS SQL:

select convert(xml,replace((select * from Name for xml path('')),' ', ''))

and need to convert this query in TeraData syntax.

 

I read that there is a procedure XMLPUBLISH in Teradata which transforms my query in XML format (like  for xml path('') in MS SQL).

But I have been unable to find an example of using this procedure.

 

Please, help convert the request into Teradata syntax (with this function or other).

Tags (1)
2 REPLIES
Teradata Employee

Re: Convert MS SQL 'for xml path()' to Teradata syntax.

Did you look in the XML Manual? Go to info.teradata.com, click on Database, select your release, and find the XML manual.

Re: Convert MS SQL 'for xml path()' to Teradata syntax.

Yes, thank you, but I have read the documentation before asking the question. 

I was there and found out about the XMLPUBLISH procedure.

But I repeat that there are no examples of the use of this procedure there and elsewhere.

And I am only interested in how to present the result set in the XML form in Teradata:

select * from Name for xml path('').

result in MS SQL(COL1, COL2 is names of columns and 1,2,qwerty,ASDD is values in this columns) :

<COL1>1</COL1><COL2>qwerty</COL2><COL1>2</COL1><COL2>ASDD</C‌​OL2>