HEADING - creates a report heading
Command format:
.SET HEADING 'heading specifier'
RTITLE (report title) - creates a report heading
Command format:
.SET RTITLE 'heading specifier'
Note: The two commands are variations of the same command. The RTITLE command is easier to use because it automatically includes the report date and page numbers.
FOOTING - creates a page footer
Command format:
.SET FOOTING 'footing specifier'
The specifier has the following format for both headers and footers:
'a||b||c//d||e||f//g||h||i'
where:
and:
To break a header line and begin a new line of header text, insert a pair of slashes (//) at the required break point. Up to nine break points can be entered for a maximum of 10 header lines within a HEADING or FOOTING command.
Specify only the entries needed, with the appropriate separator characters. If the left‑middle‑right entries are not specified, BTEQ centers the text. If the first‑second‑third lines are not specified, BTEQ puts the text on the first line.
If more than two pair of line separator characters are specified, indicating more than three lines, the following occurs:
System Type |
Results |
Mainframe-attached system |
BTEQ returns an error message and treats the additional separators as header or footer text. |
Workstation-attached system |
BTEQ truncates the additional separators from the header or footer text. |
Example
In a mainframe-attached system, using the following FOOTING command and SELECT statement:
.footing '&DATE||Confid||dential||Page&PAGE
select * from department;
The above example produces the following error message and report:
.footing '&DATE||Confid||dential||Page&PAGE
*** Warning: Maximum of 2 '||' separators is allowed,
others ignored.
*** Query completed. 5 rows found. 4 columns returned.
90/08/10 select * from department; Page 1
DeptNo DeptName Loc MgrNo
------ -------------- --- -----
500 Engineering ATL 10012
700 Marketing NYC 10021
300 Exec Office NYC 10018
600 Manufacturing CHI 10007
100 Administration NYC 10011
Refer to “HEADING” on page 194, “RTITLE” on page 293, and “FOOTING” on page 181 for additional information and examples of specifying report headers and footers.