 |
 |
Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2004 @ 22:18:18 GMT
| 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....
| |
