Previous Topic: Following Batch Execution StepsNext Topic: Changing an SQL Report Format for Batch Execution

Executing in Batch › Using the BATCH EXECUTION Panel

Using the BATCH EXECUTION Panel

Description

When you select <PF4> SUBMIT from the DIRECTORY OF QUERIES panel, CA Dataquery displays the BATCH EXECUTION panel. At some sites, batch execution might be prohibited. If this is the case at your site, the SUBMIT PF key will not function. See your CA Dataquery Administrator for batch submission authorization. You complete entries on this panel and press a PF key to continue 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 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

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. The following figure describes the use of each field on the BATCH EXECUTION panel (DQE40).

Entries

Field

Valid Entries

Explanation

Enter name of
query to submit:

 

ACTIVE-QUERY

Query previously selected from Directory of Queries or query just executed

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 p.m. is 15:00.

Enter the name of the JCL member to use:

 

default-name:

Executes the query as specified in the JCL maintained by the CA Dataquery Administrator. If a prompt panel appears, it must be completed.

A valid JCL member name:

Use only if authorized.

Enter non-blank to use JCL for
deferred:

Enter any non-blank character to use deferred JCL.

Defer execution until time __:__ must also be selected.

Select the report type:

 

Detail and totals:

Print detail and totals, if specified in query/report definition.

Detail only
(no totals):

Print only detail lines.

Totals only (summary):

Suppress detail data.

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 hardcopy. Select this item if 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:

Any type listed

Choose one or both:

  • Detail
  • Totals

Select the output
file device type:

Tape

Output to tape (DOS only).

Disk

Output to disk (DOS only).

PF Keys

Use the following PF keys after completing the BATCH EXECUTION panel.

<PF1> HELP

Displays Help for panel.

<PF2> RETURN

Redisplays Directory of Queries panel.

<PF3> SUBMIT
  1. Begins execution process.
  2. Displays prompt panel for selection.
  3. Displays execution messages.