Specifying Column Separations - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

By default, all columns in a BTEQ report are separated by two blank characters. Use the BTEQ SEPARATOR command to specify a different number of blank characters or another character string to separate columns.

Replace the PAGEBREAK command in the previous example with a SEPARATOR command specifying a single vertical bar as the separator string, for example:

   .SET SEPARATOR “|”
   .SET SUPPRESS ON 1
   select deptno, name from employee 
   where deptno in (100, 300)  
   order by deptno;

The example above produces the following report:

   DeptNo|Name
   ------|-----------
      100|Chin M
         |Greene W 
         |Moffit H
         |Peterson J
      300|Russell S
         |Phan A
         |Leidner P