Previous Topic: (DQEL0) Dialog or PROC Value ListNext Topic: (DQEO0) Totaling Options

Panels › (DQEN0) Batch Execution

(DQEN0) Batch Execution

=>
--------------------------------------------------------------------------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 non-blank 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
Select the output file device type:      _  Tape
                                         _  Disk
 
-------------------------------------------------------------------------------
<PF1> HELP      <PF2>  RETURN      <PF3>  SUBMIT

Description

When you press a SUBMIT PF key from a panel or enter the SUBMIT command, CA Dataquery displays the Batch Execution panel. You complete entries on this panel and press a PF key to continue execution. CA Dataquery presents a prompt panel if the query is a dialog and also presents another prompt panel if the JCL requires additional specifications. For information about responding to these prompt panels, see the CA Dataquery User Guide.

Action

You can leave the default entries on the screen or change them if necessary. Use the space bar to remove entries and the keyboard keys to type different entries. Enter any character to select an option. Be sure the panel contains an entry or selection for each field on the screen.

Entry Fields

Refer to the following table for valid entries in the fields on this panel. Use the TAB and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

Item

Entry

Explanation

Enter name of query to submit:

 

ACTIVE-QUERY

Query previously selected from Directory of Queries or query just executed.

Type any valid query name

Type over ACTIVE-QUERY with a name.

Select the type of execution:

 

Immediate

Execution begins at next system opportunity.

Defer execution until time __ : __

Computer operator submits query for execution after the time specified. Time is expressed in hours:minutes using military time. For example, 3:00 PM is 15:00.

Enter the name of the JCL member to use:

A valid JCL member name

Enter the name of a valid JCL member, if authorized.

Enter non-blank to use JCL for deferred:

Enter a non-blank character

Enter any non-blank character to use deferred JCL. Defer execution until time __:__ must also be selected.

Select the report type:

 

Detail and totals

Display the whole report.

Detail only (no totals)

Shows detail lines, no WHEN/DO results and no totals.

Totals only (summary)

Show only totals and WHEN/DO results.

WHEN/DO column functions only

Suppress all contents except DQL Mode WHEN/DO results.

No detail (totals and when/do)

Suppress detail lines.

Suppress report

Do not produce report. Use when exporting.

To export print data to a sequential file, select output record type:

 

Variable comma separated

Data in character format with data fields separated by commas. Character fields will be in quotes with trailing blanks truncated. Numeric fields will have leading zeros truncated. Rows will vary in length.

Fixed-length record

Data will be exported in same type and length as retrieved from the database table. All rows will be the same length.

For variable, enter name of output set

Any valid name

Obtain a valid set name from the CA Dataquery Administrator.

For variable, select output type:

Choose one or more:

  • Detail
  • Totals
  • Tape
  • Disk

See "Select the report type."

Select the output file device type:

Choose one:

  • Tape
  • Disk

DOS only

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Exits panel.

<PF3> SUBMIT

Submits the job for batch execution. May display a prompt panel if executing dialog and a prompt panel if using JCL PROC.