Purpose
Entering the EXECUTE command and a query name on the command line and pressing Enter displays the online execution panel containing the query name. You can use that panel to execute the query and view the results. If you enter the EXECUTE command without an operand and no query is currently active, CA Dataquery displays the online execution panel with no entry in the Execute Query Named field. If you have accessed a query during this CA Dataquery session, and you enter EXECUTE *, CA Dataquery displays the online execution panel with ACTIVE-QUERY in the Execute Query Named field, meaning the last query you accessed can be executed.
You can type over any entry in the Execute Query Named field. See Panels for detailed information about the online execution panel.
When to Use It
To tell CA Dataquery to execute a query immediately online. With an active found set and query, use EXECUTE if you want to re-execute with different execution specifications, or from a different execution step, as you may want to do after editing a private query to save processing time.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
EXECUTE |
* |
Display online execution panel for the active query, if any, so you can re-execute the query from a different execution step. |
|
EXECUTE |
query name |
Display online execution panel containing operand query name. |
|
EXECUTE |
No operand |
If no active query, display online execution panel containing no query name. If a query is currently active, display online execution panel for the active query. |
Example
=> EXECUTE ------------------------------------------------------------------------DQKE0 DATAQUERY: ADMINISTRATIVE MENU ---------------------------------------------------------------------------- ENTER DESIRED OPTION NUMBER ===> __ 1. PROFILE - Display and update user profile
DQL Result
=> 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 _ REPORTING - Produce the report 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
SQL Result
=> Enter the desired options and press PF3 to execute ------------------------------------------------------------------------DQE60 DATAQUERY: ONLINE EXECUTION SQL QUERY ----------------------------------------------------------------------------- EXECUTE QUERY NAMED => ACTIVE QUERY EXECUTE STEP The first query step to execute _ SELECTION - Read and collect the data _ REPORTING - Produce the report 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> FORMAT REPORT
|
Copyright © 2014 CA.
All rights reserved.
|
|