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