Specifying Side-Titles - Basic Teradata Query

Specifying Side-Titles

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  

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