Archives of the TeradataForum
Message Posted: Wed, 15 Jan 2003 @ 15:51:31 GMT
| Subj: | | Re: Column titles and titledashes should not appear in the export file. |
| |
| From: | | Geoffrey Rommel |
| | My task is getting an ascii datafile with just the values of one column of a table without the column titles and titledashes
from the table. | |
This seems to work:
.set titledashes off
.set pagelength 2000
.export report file=goober;
select your_column...;
Of course, this redirects the output to a separate file, but that's no biggie, right?
| | I want to use these values as parameters for a variable in a shell script's "for loop". | |
bteq <
.set titledashes off
.set pagelength 2000
.export report file=goober;
select your_column...;
.quit
ZZ
for NAME in `cat goober`
do
# whatever you wish to do
done
| 
