Preparing JCL for Batch CA Dataquery Utilities

Post-Installation Tasks › Preparing JCL for Batch CA Dataquery Utilities

Preparing JCL for Batch CA Dataquery Utilities

Guidelines to assist you in preparing your JCL are provided in this guide. The sample code provided in this document is intended for use as a reference aid only and no warranty of any kind is made as to completeness or correctness for your specific installation.

For more information, see How to Obtain JCL and Sample Members on the bookshelf under By Scenario or Feature,

Note: In z/OS, the default name for this library is CABDAC. In z/VSE, sample PROCs are provided that allow you to make use of parameter substitution.

Any JOB statements should be coded to your site standards and specifications. All data set names and library names should be specified with the correct names for the installation at your site. In many examples, a REGION= or SIZE= parameter is displayed in an EXEC statement. The value displayed should be adequate in most instances, but you can adjust the value to your specific needs.

The libraries listed for searching must include the following in the order shown:

User libraries you may have defined for specially assembled and linked tables, such as DBMSTLST, DBSIDPR, DDSRTLM, DQSYSTBL, or User Requirements Tables
CA Datacom base libraries (CABDLOAD): CA Datacom/DB, CA Datacom Datadictionary, CA Dataquery, SQL
CA Common Services for z/OS or CA CIS (Common Infrastructure Services) for z/VSE base libraries
CA IPC libraries
Libraries for additional products, such as CA Datacom CICS Services, CA Datacom VSAM Transparency, CA Ideal, and so on

CA Dataquery users also need the following libraries and data sets for the following specific functions:

The z/OS data set DQOUT or the z/VSE data set DQOUTD (disk) or DQOUTT (tape) is used only if the DQBATCH execution uses the EXPORT function for variable length data. If fixed length output is generated, z/os uses DQFIXD (disk) and z/VSE uses DQFIXD (disk) or DQFIXT (tape).
In z/OS, running deferred queries with separate JCL members in batch requires, in addition to the SYSIN statement DEFER, the inclusion of a DD statement for the internal reader used by VPE. This DD statement should be:
```
    //ADRSUB DD    SYSOUT=(A,INTRDR)
```

Job Control Statements

CA Datacom/DB table definitions are not included since CA Dataquery operates with the CA Datacom/DB MUF. Use the following job control statements to execute CA Dataquery batch utilities.

z/OS JCL Statement

JOB: Initiates the job.
EXEC: Specifies the program name of the CA Dataquery utility to be run.
SYSPRINT DD: Defines the sequential output data set used for listing the output report.
SYSIN DD: Defines the control data set. It normally resides in the input stream; however, it can reside on a system input device or a direct access volume.
DQBKPFIL DD: Output data set for a DQLIBRMT backup of Query Library members as requested in the BACKUP control statements. Produces a sequential file that can reside on tape or disk. This statement is needed only in JCL specifying a DQLIBRMT backup.
DQRSTFIL DD: Input data set of Query Library members to be added to the Query Library Table as requested by a DQLIBRMT RESTORE control statement. This data set must have been created by a previous execution of DQLIBRMT and is needed only if a restore is requested.

z/VSE JCL Statement

JOB: Initiates the job.
EXEC: Specifies the program name of the CA Dataquery utility to run.
SYSLST: Defines the sequential output data set used for listing the output report.
SYSIPT: Defines the control data set that resides in the input stream.
DQQBKPT: Output tape data set for a DQLIBRMT backup of Query Library members as requested by BACKUP control statements. This data set must be on SYS010 and is needed only if tape backup is requested. If disk backup is requested, use the DQQBKPD control statement.
DQQBKPD: Output disk data set for a DQLIBRMT backup of Query Library members as requested by backup control statements. This data set must be on SYS011 and is needed only if disk backup is requested. If tape backup is requested, use DQQBKPT.
DQQRSTT: Input tape data set of Query Library members created by a previous execution of DQLIBRMT. The members are to be added to the Query Library Table as requested by the DQLIBRMT RESTORE control statement. This data set must be on SYS011 and is needed only if tape restore is requested. If disk restore is requested, use DQQRSTD.
DQQRSTD: Input disk data set of Query Library members created by a previous execution of DQLIBRMT. The members are to be added to the Query Library Table as requested by the DQLIBRMT RESTORE control statement. This data set must be on SYS011 and is needed only if disk restore is requested. If tape restore is requested, use DQQRSTT.