Executing in DQL Mode

Executing Online › Executing in DQL Mode

Executing in DQL Mode

In DQL Mode, follow these basic steps to execute a query online:

View ONLINE EXECUTION panel and change specifications if needed.
View TOTALING OPTIONS panel and change specifications if needed.
Press a PF key to initiate execution.
Respond to dialog prompt panels if they appear.
Retrieve report.
If you want to re-execute with different specifications, press <PF2> to redisplay the execution panel.

Additional information about report format and destination options appear in Using DQL Mode Reporting.

Panel

When you press <PF3> EXEC QUERY during display of the DIRECTORY OF QUERIES panel, CA Dataquery displays the following ONLINE EXECUTION panel if your USER PROFILE is set to YES for panel display.

=> ENTER THE DESIRED OPTIONS AND PRESS PF3 TO EXECUTE --------------------------------------------------------------------------DQE10 DATAQUERY: ONLINE EXECUTION ------------------------------------------------------------------------------- EXECUTE QUERY NAMED => ACTIVE QUERY EXECUTE STEP THE FIRST QUERY STEP TO EXECUTE _ SELECTION - READ AND COLLECT THE DATA _ COMPUTATION - PERFORM THE USER DEFINED CALCULATIONS _ SORTING - ORDER THE COLLECTED DATA REPORT FORMAT THE REPORT FORMAT _ COLUMNAR - SHOW THE DATA ARRANGED ONE ROW PER LINE _ LIST - SHOW THE DATA ARRANGED ONE ROW PER PAGE REPORT DESTINATION THE DESTINATION FOR THE REPORT _ VIDEO TERMINAL - PRODUCE THE REPORT ON THE TERMINAL _ NETWORK PRINTER ____ - PRODUCE THE REPORT ON A NETWORK PRINTER _ SYSTEM PRINTER - PRODUCE THE REPORT ON THE SYSTEM PRINTER ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> EXECUTE <PF4> TOTALING OPTIONS

Operation

You can leave the default entries on the screen or change them if necessary. If a query currently resides in the active query area, it will be executed if ACTIVE QUERY is the query named. You can write over it with a valid query name.

The default formatting specifications that appear on the Online Specifications are determined by the contents of the query or dialog chosen for execution. The options on the panel allow you to override the query or dialog specifications.

Use the space bar to remove entries and the keyboard keys to type different entries. Enter any character beside the selection of your choice. Be sure the panel contains an entry or selection for each category on the screen.

See the following chart for valid entries and explanations of the items on the DQL Mode ONLINE EXECUTION panel.

Field	Valid Entries	Explanation
EXECUTE QUERY NAMED	ACTIVE QUERY	Query previously selected from DIRECTORY OF QUERIES or query just executed.
EXECUTE QUERY NAMED	Any valid query name	Type over ACTIVE QUERY with a name.
EXECUTE STEP	SELECTION	First execution step.
	COMPUTATION	Re-execute beginning with math functions, if any (SET).
	SORTING	Re-execute beginning with sorting functions, if any (SORT).

REPORT FORMAT	COLUMNAR	Rows of data with columns arranged horizontally.
REPORT FORMAT	LIST	Each row appears on separate page with vertical column display.
DESTINATION	VIDEO TERMINAL	Report appears on screen.
	NETWORK PRINTER	Hardcopy appears at designated printer.
	SYSTEM PRINTER	Hardcopy appears at system printer.
REPORT FORMAT	COLUMNAR	Rows of data with columns arranged horizontally.
REPORT FORMAT	LIST	Each row appears on separate page with vertical column display.
DESTINATION	VIDEO TERMINAL	Report appears on screen.
	NETWORK PRINTER	Hardcopy appears at designated printer.
	SYSTEM PRINTER	Hardcopy appears at system printer.

If you press <PF2> RETURN after viewing a report because you want to make a change on the ONLINE EXECUTION panel (DQE10), do not start execution at SELECTION unless you have changed the FIND statement in the query. Pressing <PF3> begins the execution process, displays prompts, if any, execution messages, and then the report.

When the ONLINE EXECUTION panel is complete, press a PF key to tell CA Dataquery the next step. If you like, you can press <PF4> TOTALING OPTIONS to display another panel for changing the default (detail and totals) to another option.