Specifying Column Separations

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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

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