I am trying to export the 3 differrent select queries output to a single file (refer below)
bteq << EOB > log.txt
.export report file=result.txt
.set width 1000
.set TITLEDASHES ON;
select metric, count(*) from tab1
-- 2nd query
select metric,count(*) from tab2;
select metric, count(*) from tab3;
The above script is printing the column names 3 times in the result.txt but i want to print only once. I tried multiple options to avoid printing the column names for the 2nd and 3rd query but i couldn't able to figure it out. Could someone please help me on this.
When i tried to implement
tab2; I am getting the below error. Any idea on this..? Thanks.
*** Failure 3707 Syntax error, expected something like ';' between the word 'Metric' and '('.
Statement# 2, Info =39