Hi

I am executing isql/dbaccess and dumping the select output to a file. But the records are appearing vertically like this -

col1 val1
col2 val2
col3 val3
.....

I want to arrange the output in the following way -
col1 col2 col3 ...
val1 val2 val3 ...

That is each row of the output file will represent a record of the table.

How we can accomplish this? What flag I have to use?

Please help me out ..

Thanks