Output control

[budguy]

Hello,
need to output from bteq to a file.

Need each column from select on a new line.
(only returns one row)

Here is select:
sel col1, col2
from table1

Need output like this:
Val1
Val2

Have tried to combine some settings like
.export data file=out1
(this is good because I dont want column headings)
and tried:
.set foldline on ALL

But I keep geting an output file that has the columns on the same line:
Val1Val2

thanks in advance.

 

[tdatgod]

.sidetitles on


however this will put the column name first on each line
this is what 2 rows with 3 columns would look like.

column1 value1
column2 value2
column3 value3
column1 value4
column2 value5
column3 value6



is there a

.set titles off?