Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 11:02:43 GMT


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


Subj:   Re: XML - Export From BTEQ
 
From:   Victor Sokovin

  Is it possible to export to an XML file from a BTEQ script? If not is there another way? Any examples would be greatly appreciated. We are using Teradata 7.0.  


You are probably referring to the release version of the Teradata utilities. If so, it does not seem to be recent but even the latest versions of bteq do not support XML directly. Of course, if the XML in question is not too complicated, one could invest some effort in the SQL statement and create the headings, tags etc from within the SQL. Not a very interesting task, though.

You might be better off if you follow Mike's advice and use Teradata SQL Assistant instead of bteq:

www.teradataforum.com/teradata/20051020_144222.htm .


You might need to install/upgrade your version as XML support is probably relatively recent. I never use this feature in SQLA so I would not notice.

I prefer to use third party tools for my XML conversions. You might find some of them mentioned in the archives of this forum.


Regards,

Victor



     
  <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