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