Managing Your Query Library Table › Submitting a Query or Dialog

Submitting a Query or Dialog

A CA Dataquery Administrator may submit any query or dialog to which he has access.

Access

From the DIRECTORY OF QUERIES AND TERMS panel place the cursor on the desired query or dialog and press <PF9> SUBMIT.

Batch Execution (DQEN0)

=>

------------------------------------------------------------------------DQEN0
DATAQUERY:  BATCH EXECUTION
-----------------------------------------------------------------------------
Enter name of query to submit:           ACTIVE-QUERY
Select the type of execution:            _  Immediate
                                         X  Defer execution until time 18 : 00
Enter the name of the JCL member to use: $$DQJCL
Enter nonblank to use JCL for deferred:  _
Select the report type:
          _  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
Select the output file device type:      _  Tape
                                         _  Disk

-----------------------------------------------------------------------------
<PF1> HELP      <PF2>  RETURN      <PF3>  SUBMIT     <PF4>  NOT USED

The following steps explain how to use the BATCH EXECUTION panel.

Step 1

Verify the name of the query that you want to submit. A default query appears in the name of the query field but you may change it.

Step 2

Select the type of execution: Immediate or Deferred. (See Type of Execution following.)

Step 3

Enter the preferred JCL member name in the JCL name field.

Step 4

Select the report type. (Explanations of each follow.)

Step 5

(Optional) Data produced by the query may be exported. Select the output record type.

Step 6

After all desired options have been entered, press <PF3> to continue with batch submission.

Type of Execution

There are two types of execution, each is explained below:

Immediate

Schedules the query as soon as you press <PF3> SUBMIT.

Deferred

A batch job may be deferred by typing any character in the blank before Defer execution until time __ : __ and filling in the time for execution in the appropriate space. The format for the time is based on a 24-hour clock, with midnight being 00:00. This panel tells the job to run at 6:00 PM.

The following fields appear on this panel:

Panel Description

QUERY NAME

(Required) The name of the query being submitted.

JCL NAME

(Required) The name of the JCL member or JCL PROC to use to run the selected query in batch.

JCL FOR DEFERRED

(Optional) The JCL member named above is to be used for deferred DQBATCH execution.

REPORT TYPE

(Optional) The totaling options for the query.

EXPORT RECORD TYPE

(Optional) To use the export function select either:

VARIABLE COMMA SEPARATED

For output of variable-length comma separated record to the export file.

FIXED LENGTH RECORD

For output of fixed-length records to the export file.

EXPORT FILE

(Optional) The file name for variable record output. Not used for fixed-length export data.

EXPORT OUTPUT TYPE

(Optional) The output type to write to the export file for variable record output. Not used for fixed-length export data.

OUTPUT DEVICE

(Optional) The device for the exported file, disk, or tape, for DOS only.