DQL Statements › DISPLAY Statement › Alternate Output Headings

Alternate Output Headings

Purpose

The DISPLAY statement also allows you to specify alternate headings for the displayed output.

Syntax Diagram

To assign alternate headings to display for each column or key, use the following DISPLAY format.

►►─ DISPLAY ─┬────────┬─┬─────────────────────────────┬───────────────────────►
             └─ FROM ─┘ └─ table-name ─┬────────────┬─┘
                                       └─ (status) ─┘

 ►─┬─ key-name ────┬─┬─────────────────────────────────┬──────────────────────►
   └─ column-name ─┘ └─ 'heading1 ─┬─────────────┬─ ' ─┘
                                   └─ /heading2 ─┘

 ►─┬──────────────────────────┬───────────────────────────────────────────────►◄
   └─ PICture 'edit-pattern' ─┘

Repeat parameters once for each key or column.

Explanation

The following explains each keyword in the DISPLAY syntax used to produce alternate output headings.

'heading1 / heading2'

Assigns an alternate column heading name for the preceding column or key. A heading name can be up to 32 characters, including blanks, and must appear within apostrophes ('). If you do not specify a heading name, CA Dataquery prints an alternate heading from Datadictionary, if your site management selected that choice as a system option; otherwise, CA Dataquery prints the Datadictionary name of the column or key. Column headings can be two lines of 22 characters each, separated by a site-specified heading separator character, such as a slash (/). See the System Profile topic on the Topic Help panel for the heading separator used at your site.

PICTURE 'edit-pattern'

See PICTURE Clause for information about PICTURE clauses.

Example

The following is a sample query and query output illustrating the use of designated one- and two-line headings.

    FIND 10 CAI-SLSHST-REC ROWS
    DISPLAY FROM CAI-SLSHST-REC SLMN-ID
                                'REPRESENTATIVE/ID NUMBER
                                ORD-ID
                                'ORDER NUMBER'

Output

 =>
 
 ------------------------------------------------------------------------DQED0
 DATAQUERY:  COLUMN VALUE DISPLAY                      ROW 00001 PAGE 00001
 -----------------------------------------------------------------------------
 REPRESENTATIVE
 ID NUMBER                        I4790
 ORDER NUMBER                     01002
 
 
 
 
 
 
 
 
 
 
 
 
 
 -----------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN        <PF3> PREV ROW      <PF4> NEXT ROW
 <PF5> NOT USED      <PF6> STATS         <PF7> BACKWARD      <PF8> FORWARD