Panels › (DQE10) Online Execution

(DQE10) Online Execution

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

Description

The Online Execution panel lets you request immediate use of system resources to query the database table and return information in the form of a report. You can enter a query name or execute the ACTIVE-QUERY. You can also specify a beginning execution point (for re-executions), a report format, and a destination.

Action

Leave the default entries on the panel or change them as needed. Follow these steps:

1. Verify that the query named is the one you want to execute.
2. Decide which query step to use for execution to begin. Only select a step that is appropriate for the query.
3. Select a report format. Leaving both options blank tells CA Dataquery to use the format specified in the query.
4. Select the output destination.
5. To view or change totaling options, display the Totaling Options panel with <PF4> TOTALING OPTIONS.
6. Press <PF3> EXECUTE.

Entry Fields

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.

EXECUTE QUERY NAMED =>

Use ACTIVE QUERY for query previously selected from Directory of Queries or query just executed.

Use any valid query name; type over ACTIVE-QUERY with a name.

EXECUTE STEP

(Choose one.)

SELECTION

First execution step. (FIND) Do not select unless FIND statement is changed or query is no longer active.

COMPUTATION

Re-execute beginning with math functions, if any. (SET)

SORTING

Re-execute beginning with sorting functions, if any. (SORT)

REPORTING

Re-execute beginning with report production. (PRINT/DISPLAY)

REPORT FORMAT

COLUMNAR

Rows of data with column headings.

LIST

Each row appears on a separate screen. (Not available if routing output to network printer.)

REPORT DESTINATION

VIDEO TERMINAL

Report appears on screen.

NETWORK PRINTER ______

Hardcopy appears at printer designated in ______ unless List option chosen.

SYSTEM PRINTER

Hardcopy appears at system printer.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help for panel.

<PF2> RETURN

Redisplays Directory of Queries panel.

<PF3> EXECUTE

1. Begins execution process.
2. If dialog, displays prompt panel for selection.
3. Displays execution messages.
4. Displays report if destination is video terminal.

<PF4> TOTALING OPTIONS

Displays Totaling Options panel for changing options.