Using Display Commands in a Request

How to:

The four display commands (PRINT, LIST, SUM, and COUNT) are also known as verbs. These commands are flexible; you can report from several fields using a single command, and include several different display commands in a single report request.


Top of page

x
Syntax: How to Use Display Commands in a Request
display [THE] [SEG.]fieldname1 [AND] [THE] fieldname2 ...

or

display *

where:

display
Is the PRINT, LIST, SUM, or COUNT command. WRITE and ADD are synonyms of SUM and can be substituted for it.
SEG.
Displays all fields in a segment (a group of related fields in a Master File). The field name you specify can be any field in the segment.
fieldname
Is the name of the field to be displayed in the report.

The maximum number of display fields your report can contain is determined by a combination of factors. For details, see Maximum Number of Display Fields Supported in a Request.

The fields appear in the report in the same order in which they are specified in the report request. For example, the report column for fieldname1 appears first, followed by the report column for fieldname2.

The field to be displayed is also known as the display field.

AND
Is optional and is used to enhance readability. It can be used between any two field names, and does not affect the report.
THE
Is optional and is used to enhance readability. It can be used before any field name, and does not affect the report.
*
Applies the display command to every field in the left path of the data source.

Note: The SEG. and * options do not display virtual fields. To print virtual fields, explicitly reference them in the PRINT statement (PRINT * virtual field name). This is true even if the virtual field name redefines a real field.


WebFOCUS