PROFILE command

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


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


FIELDS numeric_field

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


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.


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


The following example profiles the Rate field.

OPEN Employee_Payroll

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