NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
H-1
H
HEADING Clause
HEADING is a clause in the ALTER TABLE, ALTER VIEW, CREATE TABLE, and
CREATE VIEW statements that specifies a default heading for a column.
HEADING string
specifies a default heading for a column, expressed as a string of single-byte or
multi-byte characters enclosed in single or double quotation marks. string can be
0 to 132 bytes long.
string cannot include the character string specifier normally allowed on a string
literal.
To indicate line breaks in a heading, use the new-line character. The default new-line
character is a slash (/). You can specify up to 50 lines in a single heading.
NO HEADING
specifies that no default heading should be printed for the column.
Considerations—HEADING
•
If you do not specify the HEADING clause, SQL uses the column name when
printing or displaying the column.
Examples—HEADING
•
The following ALTER TABLE statement specifies Customer as the default heading
for column CUSTOMER_NAME in table CUST. The new heading replaces any
existing heading for the column.
ALTER TABLE CUST COLUMN CUSTOMER_NAME HEADING "Customer"
HEADINGS Option
HEADINGS is an option of the report writer SET STYLE command that activates or
suppresses the printing of headings in the current report and in subsequent reports until
you reset the HEADINGS option or end the SQLCI session.
Setting HEADINGS OFF is the same as specifying NOHEAD for every print item in
your report.
HEADING string | NO HEADING