When you select <PF4> SUBMIT from the DIRECTORY OF QUERIES panel (See the section beginning on Step 1: Select a Query or Dialog.) CA Dataquery displays the BATCH EXECUTION panel. At some sites, batch execution may 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. 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 <PF4> NOT USED
You can leave the default entries on the screen or change them if necessary. Using the keyboard keys, use the space bar to remove entries and the alpha and numeric keys to type 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 describes the use of each field on the BATCH EXECUTION panel (DQEN0).
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled Enter name of query to submit:
Query previously selected from Directory of Queries or query just executed.
Type over ACTIVE-QUERY with a name.
Follow directions on the next table to change the Batch Execution panel default for the field labeled Select the type of execution:
Execution begins at next system opportunity.
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.
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled Enter the name of the JCL member to use:
JCL specifies such execution options as the printer destination and executes the query as specified in the JCL maintained by the CA Dataquery Administrator. If a PROMPT panel appears, it must be completed.
Use only if authorized.
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled Enter nonblank to use JCL for deferred:
Defer execution until time __:__ must also be selected.
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled Select the report type:
Print detail and totals, if specified in the query (DQL Mode) or the report definition (SQL Mode).
Print only detail lines.
Suppress detail data.
Suppress all contents except DQL Mode When/Do results.
Suppress detail lines.
Do not produce hardcopy. Select this item if exporting.
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled To export print data to a sequential file, select output record.
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.
Data will be exported in same type and length as retrieved from the database table. All rows will be the same length.
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled For variable, enter name of output set.
Obtain a valid set name from the CA Dataquery Administrator.
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled For variable, select output type:
Choose one or both:
Follow directions on the next table to change the BATCH EXECUTION panel default for the field labeled Select the output file device type:
Output to tape (z/VSE only).
Output to disk (z/VSE only).
|
Copyright © 2014 CA.
All rights reserved.
|
|