Previous Topic: Online SQL ExecutionNext Topic: Choose an Online Output Destination


Online DQL Execution

The DQL Mode version of the ONLINE EXECUTION panel includes report formatting options because data arrangement is done at execution.

Presentation of totals and subtotals can be changed with the TOTALING OPTIONS PF key at the bottom of this panel or with the PF keys available during online output.

 =>   ENTER THE DESIRED OPTIONS AND PRESS PF3 TO EXECUTE  --------------------------------------------------------------------------DQE20  DATAQUERY:  ONLINE EXECUTION  -------------------------------------------------------------------------------    EXECUTE QUERY NAMED => ACTIVE-QUERY    REPORT FORMAT                 THE REPORT FORMAT     X  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     X  VIDEO TERMINAL            - PRODUCE THE REPORT ON THE TERMINAL     _  NETWORK PRINTER  DH86     - 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

Select a format and an output destination (according to Choose an Online Output Destination). If you need to specify presentation of numeric totals, see Changing Online DQL Mode Totaling Options, which covers the TOTALING OPTIONS panel that you can display while viewing the DQL Mode ONLINE EXECUTION panel.

When entries are complete, press <PF3> EXECUTE to execute the query and display the online output.