Purpose
This command displays the execution statistics for the active query or dialog.
When to Use It
Use the STATS command when you want to know how many rows were found, why a query terminated if not due to normal end of search, and system statistics about the search for data.
Note: If the STALL command has been issued during this session, additional statistics appear. See (DQEC0) FIND Statistics for more information.
Syntax (DQL Mode)
|
Enter |
With |
When You Want to: |
|---|---|---|
|
STATS |
No operand |
Display Find Statistics panel for the active query. |
Syntax (SQL Mode)
|
Enter |
With |
When You Want to: |
|---|---|---|
|
STATS |
No operand |
Display search statistics or table statistics for the active query. |
Example
=> STATS ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: SHOW EDITOR LINE COMMAND FUNCTIONS ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 03 FIND 10 CAI-SLSHST-REC 04 WITH SHIP-QTY > 100 05 RELATED BY ITM-ID TO CAI-RCPTS-REC 06 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE
Result
=> Current Dataquery FIND/SELECT Statistics. ------------------------------------------------------------------------DQEF0 DATAQUERY: FIND STATISTICS QUERY NAME: USER-SAMPLE ----------------------------------------------------------------------------- NUMBER REQUESTED: ALL COMPLETION DATE: 06/04/88 NUMBER FOUND: 97 COMPLETION TIME: 14:25:46 FIND TERMINATED BECAUSE: NORMAL END OF SEARCH WAS REACHED OVERALL OPTIMIZATION SEARCH ------- ------------ ------- ELAPSED TIME (SECONDS): 2 0 0 I/O EVENTS: 2 0 2 SELFR TOTAL: 2 1 1 SELNR TOTAL: 97 97 TOTAL BYTES: 351 ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN
|
Copyright © 2014 CA.
All rights reserved.
|
|