Previous Topic: Special Considerations for DQL Language QueriesNext Topic: Estimated Statistics


Data Selection Status

When using DQL Language, if your query or dialog runs longer than permitted by the values specified in the MXREQ and MXTLR fields on the User Table Maintenance Menu, CA Dataquery displays the Data Selection Status panel. An example follows:

Data Selection Status (DQE50)

=> Press the appropriate PF key. ------------------------------------------------------------------------DQE50 DATAQUERY: DATA SELECTION STATUS ------------------------------------------------------------------ ----------- Number of records selected => Press PF3 to end SELECTION and report on only the records selected so far. Press PF4 to continue execution of the SELECTION Step. ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> END SELECT <PF4> CONTINUE

Panel Description

The Data Selection Status panel shows how many rows have been selected by the execution of the FIND statement in your query or dialog up to this point in the execution of the query. The panel appears because CA Dataquery has paused during execution of your query so that you can indicate whether you want to end the selection step, continue the query selection step, or return to the Online Execution panel.

PF Keys

Key

Objective

Result

CLEAR

Return to Main Menu.

Returns to the Main Menu.

<PF1> HELP

Display HELP panel.

CA Dataquery displays the Help panel.

<PF2> RETURN

Return to previous panel.

Returns to previous panel, or Main Menu.

<PF3> END SELECT

End the row selection,
but continue executing the query or dialog.

CA Dataquery executes the remainder of the query or dialog.

<PF4>CONTINUE

Continue the query or dialog selection.

CA Dataquery continues to select rows.