|
|
Archives of the TeradataForum
Message Posted: Thu, 10 Feb 2000 @ 05:56:48 GMT
Subj: | | Re: BTEQ Sentences |
|
From: | | Barbara George |
| I'm using the following BTEQ SCRIPT to obtain a flat file. This script returns a file with the name of the columns used in the
select sentense as the header. | |
| What setting or additional sentece should I use to avoid the header in the output file? Additional, this header appears every
certain number of lines as a page break. I'm looking for a solution to avoid all the headers. | |
I have found using the 'title' phrase with an empty string eliminates the heading for a column, eg:
SELECT CodProducto (title ''), ..... etc
There is probably a quicker and better way to do this, but my output file had only 1 column, and this worked.
Barbara George
Manager, Decision Support, Pick 'n Pay Information Systems
Cape Town, South Africa
| |