Archives of the TeradataForum
Message Posted: Thu, 05 Feb 2004 @ 13:59:55 GMT
| 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.