Specifying Column Separations - Basic Teradata Query

Example – SEPARATOR

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;

This example produces the following report:

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