By default, BTEQ presents each row of output data as one row in the reports, with each column presented side by side in a horizontal format.
For example, use the following SELECT statement:
SELECT DeptNo, Name, JobTitle, Salary
FROM Employee WHERE DeptNo = 300;
The above example produces the following report:
DeptNo Name JobTitle Salary
------ ------------ ------------ ---------
300 Russell S President 65,000.00
300 Phan A Vice Pres 55,000.00
300 Leidner P Secretary 23,000.00