Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Feb 2004 @ 13:59:55 GMT

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

Subj:   Re: How to print heading one time only in a BTEQ query?
From:   Geoffrey Rommel

You might consider writing a Perl script. Using DBI and (DBD::Teradata or DBD::ODBC), you can print out the column titles and the data in whatever form you want. This would also get around BTEQ's restrictions on the line width. The tricky part is that BTEQ uses Field mode, whereas those modules return the data in Perl internal form, so you have to do your own formatting of numerics. Still easier than C, though.

  <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