Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 17:32:25 GMT

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

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

  so for example, i will have a heading containing customer #1's name, then 100,000 rows of data, then a pagebreak when i get to customer #2 and a new heading with that customer's name in it and then that customer's data and so on (this is why the suggestion of concatenating a heading and report file together will not work).  

The report heading (as defined by HEADING or RTITLE in BTEQ) is pretty much fixed for the report. The only varying data is the page number. So, how will you get customer names into the heading at all? The only way to do that would be to run one report per customer at a time and hardcode the customer name into the heading as you generate BTEQ scripts on the fly from some shell-level loop on customer name.

Alternatively, you could just include customer_name as one of the columns in your report and use SUPPRESS on it. That would print each customer name only once; not as title, though, but rather on the first data output line for the customer. This will make your report a bit wider but, hey, it is already long enough to start worrying about readability. By the way, you can always improve your layout when the data is imported into Excel.



  <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