SQL$HELP72.HLB  —  DATATRIEVE  QUERY HEADER Clause
    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.
Close Help