Vertical Presentation - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

Use the BTEQ FOLDLINE command to break each row of output data into two or more rows in the report. Using the FOLDLINE ON ALL form of the command effectively changes the format of the report from horizontal to vertical by reporting each column value on a new line.

Add a FOLDLINE command to the previous example to reformat the report as shown in the example report below:

.SET FOLDLINE ON ALL
SELECT Name, JobTitle, Sex
FROM Employee WHERE DeptNo = 300;

Example report:

Name     
------------ 
        JobTitle
        ------------
         Sex
         --- 
Russell S
        President
         M
Phan A
        Vice Pres
         F
Leidner P
        Secretary
         F

To reposition the column headings to the left of the rows, use the BTEQ SIDETITLES command, described in the following subsection.