Purpose
Inserts two blank lines in a report whenever the value of a specified column changes.
Syntax
where:
|
Syntax Element |
Specification |
|
n |
Column numbers are ordered from left to right and separated by a comma or one space. The value of n can range from 1 to 2048. |
Usage Notes
Use the SKIPDOUBLE command to insert blank space between different sections of a report. BTEQ inserts two blank lines when the value of any of the specified columns changes, or if the value of more than one column changes at the same time.
If the ALL option of the SKIPDOUBLE command is specified, BTEQ triple spaces the report. If the ALL option is specified for both the SKIPDOUBLE command and the SKIPLINE command, BTEQ quadruple spaces the report.
The initial configuration of the SKIPDOUBLE command options are OFF and ALL. If ON or OFF are not specified, or column numbers are not included, BTEQ sets SKIPDOUBLE to ON ALL.
The SKIPDOUBLE setting only affects the output for Field Mode, not Record Mode, Indicator Mode, or Multipart Indicator Mode.
The SKIPDOUBLE command can be used in a Teradata SQL macro.
Example
In the following example, the first SELECT operation omits the SKIPDOUBLE command and the second SELECT includes it.
database workforce;
.defaults
.format on
select name
,empno
,deptno from employee
order by deptno
;
.defaults
.format on
.heading "set skipdouble all"
.set skipdouble all
= 1
.format off
BTEQ Response
*** Query completed. 21 rows found. 3 columns returned.
90/07/24 select name, empno, deptno from employ ... Page 1
Name EmpNo DeptNo
------------ ----- ------
Peterson J 10001 100
Chin M 10011 100
Greene W 10017 100
Moffit H 10002 100
Russell S 10018 300
Leidner P 10003 300
.
.
.
(etc)
*** Query completed. 21 rows found. 3 columns returned.
Name EmpN DeptNo
------------ ----- ------
Peterson J 10001 100
Chin M 10011 100
Greene W 10017 100
Moffit H 10002 100
Russell S 10018 300
Leidner P 10003 300
.
.
(etc)
Example 2
To print two blank lines when the value changes for columns 1 or 5, type:
.SET SKIPDOUBLE ON 1,5
Example 3
The Example 2 SKIPDOUBLE command in a Teradata SQL macro appears as:
ECHO '.SET SKIPDOUBLE ON 1,5';