Expanding Byte Precision for COUNT and LIST

How to:

Set the Precision for COUNT and LIST

By default, the number of characters that display for counter values retrieved using the COUNT and LIST commands is five. You can increase the number of characters to nine.

For example, if the number of records retrieved for a field exceeds 99,999 (5 bytes), asterisks appear in the report to indicate an overflow condition. You can increase the display to allow as large a count as 999,999,999 (9 bytes) using SET COUNTWIDTH.

Note: You can change the overflow character by issuing the SET OVERFLOWCHAR command.

Syntax: How to Set the Precision for COUNT and LIST

SET COUNTWIDTH = {OFF|ON}

where:

OFF: Displays five characters (bytes) for COUNT and LIST counter values. Asterisks are displayed if the number of records retrieved for a field exceeds five characters. OFF is the default.
ON: Displays up to nine characters (bytes) for COUNT and LIST counter values. Asterisks are displayed if the value exceeds nine characters.

Example: Setting Precision for COUNT and LIST

The following example shows the COUNT command with SET COUNTWIDTH = OFF:

TABLE FILE filename 
COUNT Fldxx 
BY Fldyy
END

	Fldxx
Fldyy	COUNT
value	*****

The following example shows the COUNT command with SET COUNTWIDTH = ON:

TABLE FILE filename 
COUNT Fldxx
BY Fldyy
END

	Fldxx
Fldyy	COUNT
value	999999999

Note: This feature affects the width of a report when COUNTWIDTH is set to ON. Calculating the width of a report now requires an additional four display positions for each COUNT or LIST column.