Previous Topic: Using Output CommandsNext Topic: Creating a Personal Table from Output


Viewing Query Statistics

If you press <PF6> STATS while viewing a report on your terminal screen, you can display a panel as shown in the following example.

=> Current Dataquery FIND/SELECT Statistics. --------------------------------------------------------------------------DQEF0 DATAQUERY: FIND STATISTICS QUERY NAME: TESTSQL001 ------------------------------------------------------------------------------- NUMBER REQUESTED: All COMPLETION DATE: NUMBER FOUND: 9 COMPLETION TIME: FIND TERMINATED BECAUSE: NORMAL END OF SEARCH WAS REACHED OVERALL OPTIMIZATION SEARCH ------- ------------ ------ ELAPSED TIME (SECONDS): 1 0 0 I/O EVENTS: 0 0 0 SELFR TOTAL: 0 0 0 SELNR TOTAL: 0 0 TOTAL BYTES: 0 ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN

The QUERY STATISTICS panel gives you information about how the query functioned when you executed it. Details about the meaning of each field are available in the CA Dataquery Reference Guide and from your CA Dataquery Administrator.

You might need to pass this information to your CA Dataquery Administrator if you should experience problems in executing a query. Press <PF3> if you do not want to include a cover letter with