Getting a Report › Choosing an Execution Method

Choosing an Execution Method

After you select a query or dialog, issue the command or press the PF key that starts the execution method you want to use. Execution methods are described below.

EXEC or EXECUTE

(PF key or command)

Choose online execution when you want the results of a query or dialog to appear immediately on your terminal screen or if you want immediate execution of a hardcopy.

SUBMIT

(PF key or command)

Choose batch execution when you:

• Do not need a report on the screen
• Know the processing takes a long time
• Want to delay processing
• Want to export the results instead of print them

Panels

Following are two panels for executing queries. The first is the ONLINE EXECUTION panel (for SQL Mode) and the next is the BATCH EXECUTION panel. SQL Mode and DQL Mode ONLINE EXECUTION panels are almost the same. The only real differences are that in DQL Mode you can restart execution at various points in the process of computation, sorting, and executing. In SQL Mode, you can revise the default report format. (For an example of the DQL Mode ONLINE EXECUTION panel, see Executing in DQL Mode.)

ONLINE EXECUTION Panel (SQL Mode)

 =>
  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
    _  REPORTING                 - Produce the report

   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

BATCH EXECUTION Panel (SQL Mode)

 =>
-----------------------------------------------------------------------DQEN0
  DATAQUERY:  BATCH EXECUTION
-----------------------------------------------------------------------------
 Enter name of query to submit:           ACTIVE-QUERY
 Select the type of execution:            X  Immediate
                                          _  Defer execution until time __ : __
 Enter the name of the JCL member to use: $$DQJCL
 Enter nonblank to use JCL for deferred:  _
 Select the report type:
           X  Detail and totals           _  When/do column functions only
           _  Detail only (no totals)     _  No detail (totals and when/do)
           _  Totals only (summary)       _  Suppress report
  To export print data to a sequential file, select output record type:
           _  Variable comma separated    _  Fixed length record
  For variable, enter name of output set   _______________
  For variable, select output type:        _  Detail
                                           _  Totals



  -----------------------------------------------------------------------------
  <PF1> HELP      <PF2>  RETURN      <PF3>  SUBMIT

Authorization

If the ONLINE EXECUTION panel does not appear on your screen, it means it is being suppressed, probably as a site standard. If you are authorized to change your profile, you can change this specification with the PROFILE option on the Administrative Menu. If you cannot change your profile, the ONLINE EXECUTION panel does not appear and the PF keys will initiate execution with default selections shown on previous panel samples.

Also, batch execution can be prohibited. If you want to use batch execution, see your CA Dataquery Administrator. If you cannot use batch, the SUBMIT PF key will not function.

Options

When a query or dialog author defines a report's appearance with mathematical functions or totaling options, you can specify whether you want to see detail data or totals. You can also change the definition with online execution. (See n for details.)

With the ONLINE EXECUTION panel, you can specify a destination different from the defaults. To change the destination with batch execution, you must change the JCL. The only way you can access the JCL is if a JCL prompt appears or if you have CA Dataquery Administrator authorization to update JCL.

The following table shows you which report options are available with each type of execution.