How to Specify Side Titles | Basic Teradata Query - Specifying Side Titles - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
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 following example report:

.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