The QUERY HEADER clause specifies the column header that SQL uses
in displays of result tables that contain that column.
If you include the QUERY HEADER clause, SQL uses the query header
as the column header. If you omit the clause, SQL uses the column
name as the column header.
The column header can include any character except a carriage
return, a line feed, or a control character. To include a double
quotation mark in a column header, enclose it in single quotation
marks.
The following example defines a query header for one column and a
DATATRIEVE query name for another column:
SQL> ALTER TABLE TEMP
cont> ADD STATE CHAR (2)
cont> QUERY NAME FOR DATATRIEVE IS 'ST'
cont> ADD SEX CHAR (1)
cont> QUERY HEADER IS 'S'/'E'/'X';
These statements define query headers and query names for the
STATE and SEX columns. The slash character (/) specifies that
the header is split into three lines, so the header for the SEX
column is 1 character wide, like the column itself.
Both SQL and DATATRIEVE display the query header used in this
example. Only DATATRIEVE recognizes the query name.