How to Insert Blank Lines | Basic Teradata Query - Inserting Blank Lines - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Instead of, or in addition to, using the BTEQ SUPPRESS command, use the SKIPLINE and SKIPDOUBLE commands to insert one or two blank lines in a report whenever the value of a specified column changes.

Example – SKIPLINE or SKIPDOUBLE

Adding a BTEQ SKIPLINE command to the previous example produces the example report shown below:

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

Example report:

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

Similarly, using a SKIPDOUBLE command adds two blank lines, and using both SKIPLINE and SKIPDOUBLE adds three.