Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 22:18:18 GMT

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

Subj:   Re: How to print heading one time only in a BTEQ query?
From:   Meade, Cornelius

One possibility....Many years ago I built an application that sounds quite similar to yours at a high level....In that case, I 3-4 different reports that were being sent to multiple locations based on data extracted from a Sybase database. Any particular site could get 1 or all of the reports but the layout for a particular discrete report was the same for all sites. This meant that if I saved a generic report heading for the report in question off into a file, it could be appended in front of the associated report data as needed. This only had to be done one time and the saved, generic report headings could be used over and over as needed. When the system ran, the data for a particular report was generated, the a copy of the appropriate heading file was made. The copied heading file was then customized using SED (as the system I this stuff was running on was UNIX based) to plug in site specific information into the report heading (such as site name, date, time, etc.) then the report data was appended to the copied heading file. ....And so on....Anyway, something similar might work for you since if you need to append all reports for all sites into a singe file to feed your downstream process, you could do that as well....

  <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: 27 Dec 2016