Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Can we get Bteq output in HTML format?
 
From:   John Adams

From: John Adams

  You can also get XML output in this manner.  


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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023