Executing Online › Executing in SQL Mode

Executing in SQL Mode

In SQL Mode, follow these basic steps during execution:

1. View ONLINE EXECUTION panel and change specifications if needed.
2. In SQL Mode, press <PF4> FORMAT REPORT to view or change report format.
3. Press <PF3> EXECUTE to initiate execution.
4. Respond to dialog prompt panels if they appear.
5. Retrieve report.
6. The query format for the report is not saved in the query library unless the query is saved. Otherwise, the format functions only for the active query.

Panel

When you press <PF3> EXECUTE during display of the DIRECTORY OF QUERIES panel, CA Dataquery displays the following ONLINE EXECUTION SQL QUERY panel.

 =>
  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

   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       

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 because you previously selected or executed it, it will be executed unless you change ACTIVE QUERY to another valid query name.

Use the space bar to remove entries and the keyboard keys to type different entries. Enter any character beside the selection of your choice.