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).