The Directory report can be run at anytime without performing any type of maintenance on the Query Library Table. If you have a user that has left the company, you could run a Directory report on this user to find out what the user had in the Query Library Table. This report lists both SQL and DQL Language queries. SQL queries are specified in the TYPE= option as SQL. DQL Language queries are specified as QUERY in the TYPE= option. The query type is displayed on the report.
To run a Directory report, you need to add a SIGN/ON and a REPORT control statement to your JCL member as follows.
Sample z/OS JCL
//jobname See Preparing JCL for Batch CA Dataquery Utilities.
//S1 EXEC PGM=DQLIBRMT
//STEPLIB See Preparing JCL for Batch CA Dataquery Utilities.
//SYSUDUMP DD SYSOUT=*
//SNAPER DD SYSOUT=*
//SYSPRINT DD SYSOUT=* Print Output
//SYSIN DD * Command input
SIGN/ON userid PASSWORD password
REPORT TITLE=DIRECTORY
/*
//
Sample z/VSE JCL
* $$ JOB ... See Preparing JCL for Batch CA Dataquery Utilities.
* $$ LST ...
// JOB name
// EXEC PROC=procname Whether you use PROCs or LIBDEFs, see Preparing JCL for Batch CA Dataquery Utilities.
// EXEC DQLIBRMT
SIGN/ON userid PASSWORD password
REPORT TITLE=DIRECTORY
/*
/&
* $$ EOJ
Sample Report
Following is an example of the CA Dataquery Query Maintenance Report showing directory information:
Date: mm/dd/ccyy *********************************************************************** Page: 1 * CA Dataquery for CA Datacom * Time: hh.mm.ss * Query Maintenance Report * Version: 14.0 * Copyright © 1990-2011 CA. All rights reserved. * DQ Base 3 *********************************************************************** DD Base 2 QUERY DIRECTORY REPORT REPORT FOR INPUT RECORD: USER NAME=DQUSER 00000618 * MEMBER-NAME * *TYPE* *STA* *----------- AUTHOR -----------* *-- GROUP 1 --* *-- GROUP 2 --* *-- GROUP 3 --* DATE-ADDED LAST-USED *---------------------- DESCRIPTION -----------------------* testupshift QUERY PVT DQUSER 10/03/98 testing upshift for language A QUERY PVT DQUSER DALLAS DATACOM DATAQUERY 07/11/98 ABC1 QUERY PVT DQUSER DALLAS DATACOM DATAQUERY 10/02/97 07/12/98 ADR-CUST-RECS QUERY PUB DQUSER DALLAS DATACOM DATAQUERY 07/26/02 09/13/02 ADR-CUST-RECS FOR TEXAS ASSOC-ERROR QUERY PUB DQUSER DALLAS DATACOM DATAQUERY 06/08/98 08/12/98 QUERY HAS VALIDATION ERROR A10 JCL PVT DQUSER 05/13/98 05/13/98 JCL A11 JCL PVT DQUSER 05/13/98 JCL A12 JCL PVT DQUSER 05/13/98 05/13/98 JCL A13 JCL PVT DQUSER 05/13/98 JCL A14 JCL PVT DQUSER 05/13/98 JCL A15 JCL PVT DQUSER 05/13/98 JCL
Following is an explanation of the directory information found on the report:
Report Description
Lists each member affected by the Query Library Table maintenance.
Shows whether the member named is a query, dialog, JCL member, PROC, or term.
Shows whether the member is public (PUB) or private (PVT).
Shows the name of the member's author.
Gives a description of the member, if one exists.
Gives the date the query was created or copied.
Gives the last date the query was used.
Gives the groups associated with the particular Query Library Table member printed.
|
Copyright © 2014 CA.
All rights reserved.
|
|