Previous Topic: Changing an SQL Report Format for Batch ExecutionNext Topic: Using a Prompt Panel


Responding to Extra Panels During Execution

A prompt panel is an extra panel that requires you to enter further information before a function can be completed. You might encounter two types of prompt panels in your use of CA Dataquery. Dialog prompt panels allow you to adapt a query by replacing values. JCL PROC prompt panels let you adapt a JCL member by replacing values. By changing these values, you retain the structure of the query or JCL but alter some of the specifications.

Description

If you select a query with the type of DIALOG from the Directory of Queries for online or batch execution, a panel appears that lists the query variables you can change. If you type in the name of a JCL PROC (a JCL member that is defined with replaceable variables) on the BATCH EXECUTION panel, a panel appears listing JCL variables that you can change.

Dialog and JCL PROC authors are able to create a list of valid replacements for each character variable and a range of valid numbers for each numeric variable. If a range or list panel was created, you can display it by pressing a PF key.

All of the text on prompt panels is written by the query author. If you do not understand the instructions on any prompt panel, ask your CA Dataquery Administrator for assistance.

Operation

When you select a dialog for execution or use a JCL PROC in batch execution, prompt panels appear. When you see a prompt panel, you can accept the default variables shown or replace them with your own choices. You will use JCL PROCs only if you have been instructed to do so by your CA Dataquery Administrator and provided with valid replacements for the variables.

Example

Selecting a dialog and completing the execution panel (online or batch) causes a prompt panel as shown in the following example to appear. The panel describes the query and each variable that can be replaced. The variables on the next screen are Dallas and 75242.

=> --------------------------------------------------------------------------DQEX0 QUERY PRINTS A LIST OF ALL CUSTOMERS IN A SELECTED CITY, ALONG WITH CUSTOMER NAME, CUSTOMER NUMBER, AND TOTAL YEAR-TO-DATE SALES FOR 1986. ENTER THE NAME OF THE CITY TO BE REPORTED: 'DALLAS'__________ ENTER THE ZIP CODE TO BE REPORTED 75242 ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> EXECUTE <PF4> NOTUSED <PF5> RANGE/LIST <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD

Example

Any JCL member you use to submit a query for batch execution can contain embedded variables that you can change. If a prompt panel appears when you submit the query for execution, you use it in exactly the same way as a dialog prompt panel. Your CA Dataquery Administrator can provide you with the valid replacements for variables listed on a JCL PROC prompt panel. You might also be able to display valid replacements or ranges for the variables shown if they were created by the JCL PROC author by pressing <PF5> RANGE/LIST.

Following is a sample JCL PROC. The variables on the next panel are DQBATCH, USERID, and PASSWORD.

=> --------------------------------------------------------------------------DQEX0 THIS JCL IS SHARED BY OTHER MEMBERS OF YOUR GROUP. CUSTOMIZE IT WITH YOUR SPECIFICATIONS BY TYPING OVER THE VARIABLES LISTED BELOW. ENTER A JOBNAME NOT LONGER THAN 8 CHARACTERS DQBATCH ENTER YOUR RACF USER IDENTIFICATION, FOLLOWED BY A COMMA USERID, ENTER YOUR RACF PASSWORD PASSWORD ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> EXECUTE <PF4> NOTUSED <PF5> RANGE/LIST <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD