Panels › (DQE20) Online Execution (Associate User)

(DQE20) Online Execution (Associate User)

 =>
  ENTER THE DESIRED OPTIONS AND PRESS PF3 TO EXECUTE
 --------------------------------------------------------------------------DQE20
 DATAQUERY:  ONLINE EXECUTION
 -------------------------------------------------------------------------------
   EXECUTE QUERY NAMED => ACTIVE QUERY
 
   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 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. Select a report format. Leaving both options blank tells CA Dataquery to use the format specified in the query.
3. Select the output destination.
4. To view or change totaling options, display the Totaling Options panel with <PF4> TOTALING OPTIONS.
5. 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.

REPORT FORMAT

COLUMNAR:

Rows of data with column headings

LIST:

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

DESTINATION

(You can choose one printer in addition to screen display.)

VIDEO TERMINAL

Report appears on screen.

NETWORK PRINTER

Hardcopy appears at designated printer ID. (Not valid for LIST.)

SYSTEM PRINTERR

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 Online Execution panel. Retains selections.

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