Specifying Side Titles - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
hyz1479325149183.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

After using the BTEQ FOLDLINE command to change the format of a report from horizontal to vertical, as in the previous example, add the SIDETITLES command to reposition the report headings to the left side of the rows.

Example – SIDETITLES

Add a SIDETITLES command to the previous example to reposition the report headings as shown in the example report below.

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

Example report:

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