Controlling the Display of Empty Reports

The SET command, SET EMPTYREPORT, enables you to control the output generated when a TABLE request retrieves zero records.

The EMPTYREPORT=ANSI setting introduces ANSI-compliant handling of reports with zero records, producing a one-line report containing only the specified missing data character. If the request is a COUNT operation, however, a zero is displayed for the missing values.

Syntax: How to Control Empty Reports

Use this command:

SET EMPTYREPORT = {ANSI|ON|OFF}

Valid values are:

ANSI

Produces a single-line report and displays the missing data character or a zero if a COUNT is requested. in each case, &RECORDS will be 0, and &LINES will be 1.

If the SQL Translator is invoked, ANSI automatically replaces OFF as the default setting for EMPTYREPORT.

ON

Generates an empty report when zero records are found.

OFF

Does not generate a report when zero records are found. OFF is the default setting.

The command may also be issued from a request. For example:

ON TABLE SET EMPTYREPORT ON

Reference: Usage Notes for Displaying Empty Reports

TABLEF is not supported with SET EMPTYREPORT. When a TABLEF request retrieves zero records, EMPTYREPORT behaves as if EMPTYREPORT is set ON.
This is a change in default behavior from prior releases of FOCUS. To restore prior default behavior, issue the SET EMPTYREPORT = ON command.
SET EMPTYREPORT = OFF is not supported for HOLD FORMAT WP files or styled output formats.
SET EMPTYREPORT = ON behaves as described regardless of ONLINE or OFFLINE settings.