Archives of the TeradataForum

Message Posted: Fri, 09 Jun 2006 @ 18:02:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

From: John Adams

I should've said "in a similar manner". You won't be able to use SET SEPARATOR this way because the elements open and close with their own tags, unlike HTML tables where the tags marking each cell are identical. To get XML in this manner requires that you put SET SEPARATOR to an empty string and manually open and close the tags between each column, like this:

     SELECT '', column1, '', column2,
     '';

That's okay if you aren't doing anything large scale. If you're doing something big, I'd recommend running the query results through some simple line-oriented tool--Perl is wonderful for writing this sort of thing, as you can use it to generate your element tags off your column headings--to generate your XML.

	<Prev	Next>		<<First	<Prev	Next>	Last>>