DTRHELP.HLB  —  Commands Statements Clauses, QUERY HEADER Clause
       Specifies the column header DEC DATATRIEVE uses when it formats
       the display of a field value for the PRINT statement or for the
       Report Writer AT and PRINT statements. If you omit this clause,
       DEC DATATRIEVE uses the field name as the default column header
       when printing this field.

       Format

         QUERY_HEADER  [IS]  {"header-segment"}  [/...]

1  –  Argument

    "header-segment"

       Is the column header displayed above a column of data. If you
       specify only one character string literal, that string is printed
       on one line above the column. You can specify more than one
       character string literal by separating each from the next with
       a slash (/).  The literals are printed on successive lines,
       centered above the column.

2  –  Examples

       The following example shows how to set up a record so that when
       the DISPLACEMENT field is displayed, a column header of WEIGHT is
       used:

       06 DISPLACEMENT PIC 99999
                   QUERY_HEADER IS "WEIGHT"
                   EDIT_STRING IS ZZ,ZZ9
                   QUERY_NAME IS DISP.

       DEC DATATRIEVE prints the column header as follows:

       WEIGHT

       The following example shows how to set up a record so that when
       the LENGTH_OVER_ALL field is printed, a column header of LENGTH
       (IN FEET) is printed on two separate lines:

       06 LENGTH_OVER_ALL PIC XXX
          QUERY_HEADER IS "LENGTH" /"(IN FEET)".

       DEC DATATRIEVE prints the column header as follows:

       LENGTH (IN FEET)

       The following example shows how to set up a record so that when
       the LENGTH_OVER_ALL field is printed, a column header of Length
       Over All ("LOA") is printed on two separate lines:

       06 LENGTH_OVER_ALL PIC XXX
          QUERY_HEADER IS "Length Over All"/"(""LOA"")".

       DEC DATATRIEVE prints the column header as follows:

       Length Over All
          ("LOA")

       The following example shows how to set up a record so that when
       the LENGTH_OVER_ALL field is printed, a 3-line column header is
       printed with one letter per line:

       06 LENGTH_OVER_ALL PIC XXX
          QUERY_HEADER IS "L"/"O"/"A".

       DEC DATATRIEVE prints the column header as follows:

       L
       O
       A
Close Help