3. Installation › 3.3 Define Database Complex › 3.3.2 Generate Complex-Level JCL Jobs, PROCs, CLISTs › 3.3.2.1 Generate Complex-Level Q&R Templates

Previous Topic: 3.3.2 Generate Complex-Level JCL Jobs, PROCs, CLISTs

Next Topic: 3.3.3 Move Complex-Level CA MICS PROCs to PROCLIB

3.3.2.1 Generate Complex-Level Q&R Templates


Section 2.3.1.6, Database Complex JCL Definitions (JCLDEFC),
describes the CA MICS parameters that control the process by
which the JCL procedures, batch jobs, and TSO CLISTs required
for complex-level functions are created.

Q&R Workstation uses templates for query execution.  These
templates are generated by the CA MICS JCL generator
(JCLGEN3) using the statements defined in
sharedprefix.MICS.PARMS(JCLDEFC) along with corresponding
sharedprefix.MICS.PROTOLIB members.

The following figure shows the templates generated after
executing sharedprefix.MICS.CNTL(JCLGEN3).  In addition, the
sharedprefix.MICS.CNTL(TMPLTJOB) is generated that will copy
the templates from sharedprefix.MICS.CNTL to
sharedprefix.MICS.MQR.TEMPLATE.  This template library is
read by the CA MICS Mainframe Server when a Q&R query is
submitted.


 +------------------+---------------------------------------+
 |                  |                                       |
 |  INPUT           |   OUTPUT
 +------------------+---------------------------------------+
 |                  |                                       |
 |  sharedprefix.   |   sharedprefix.MICS.CNTL(QRCANCEL)    |
 |  MICS.PROTOLIB   |   sharedprefix.MICS.CNTL(QRDFLT1)     |
 |                  |   sharedprefix.MICS.CNTL(QRMETA)      |
 |                  |   sharedprefix.MICS.CNTL(QRPUTPDS)    |
 |                  |                                       |
 |                  |   sharedprefix.MICS.CNTL(TMPLTJOB)    |
 +------------------+---------------------------------------+

Additional user templates can be created by copying and
modifying the QRDFLT1 template, or by creating a new protolib
member and specifying the necessary JCLGEN parameters.

NOTE:  Templates cannot execute a PROC.  All the JCL must be
available for the CA MICS Mainframe Server to make the
necessary adjustments before submission.

See the Q&R Workstation Administration Guide for more
information on templates.