Previous Topic: (DQE60) Online Execution SQL QueryNext Topic: (DQE90) Query/Dialog Print Output

Panels › (DQE70) Online Execution SQL Query (Associate User)

(DQE70) Online Execution SQL Query (Associate User)

 =>
  Enter the desired options and press PF3 to execute
 --------------------------------------------------------------------------DQE70
 DATAQUERY:  ONLINE EXECUTION SQL QUERY
 -------------------------------------------------------------------------------
   EXECUTE QUERY NAMED => ACTIVE QUERY
 
   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

Description

The SQL Mode Online Execution panel for associate users 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.

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. Press <PF4> FORMAT REPORT if you need to change the format specifications for this execution.
  3. Select the output destination.
  4. 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.

Field

Valid Entries

Explanation

EXECUTE QUERY NAMED

 

ACTIVE-QUERY

Query most recently used.

Any valid query name

Type over ACTIVE-QUERY with a name.

REPORT DESTINATION (video and/or printer)

 

VIDEO TERMINAL

Report appears on screen.

NETWORK PRINTER

Hardcopy appears at printer designated (unless LIST option selected).

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> FORMAT REPORT

Displays panels for changing report specifications.