PROFILE command

Used to generate summary statistics for one or more numeric fields, or expressions, in the active ACL table.

Syntax

PROFILE {<FIELDS> numeric_field <...n>|ALL} <IF test> <WHILE test>
<FIRST|NEXT range>

Parameters

FIELDS numeric_field

Specifies the individual field(s) to profile. The FIELDS keyword can be omitted.

ALL

Specifies that all numeric fields in the ACL table should be profiled.

IF test

Optional. Specifies a condition that must be met. The command is only executed on records that pass the test.

WHILE test

Optional. Specifies that the command should only be executed while a condition is true. The command processing terminates as soon as the specified test evaluates as false, or the end of the table is reached.

FIRST | NEXT range

Optional. Specify FIRST to start processing at the first record or NEXT to start processing at the currently selected record. Use the range value to specify the number of records to process.

Remarks

The following statistics are displayed for each numeric field or expression specified for the command: Total Value, Absolute Value, Minimum, and Maximum.

Example

The following example profiles the Rate field.

OPEN Employee_Payroll
PROFILE FIELDS Rate


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback