Managing Your Query Library Table › Performing Query Table Maintenance (DQLIBRMT) › Query Text Information

Query Text Information

The Query Text report can also be run at anytime and does not require any type of maintenance to be performed to the Query Library Table. Use the Query Text report to view the text of the Query Library Table members that were on the user's online table.

To run a Query Text report, 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.

 //STEP1  EXEC PGM=DQLIBRMT

 //STEPLIB    See Preparing JCL for Batch CA Dataquery Utilities.

 //SYSUDUMP DD SYSOUT=*

 //SYSPRINT DD SYSOUT=*                            Print Output

 //SYSIN    DD *                                   Command input

 SIGN/ON userid PASSWORD password

 REPORT     TITLE=QUERYTEXT

 /*

 //

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=QUERYTEXT

 /*

 /&

 * $$ EOJ

Note: You can use more than one REPORT control statement in your JCL member. Each REPORT control statement should occur on a separate line.

Sample Report

Following is an example of the CA Dataquery Query Maintenance Report showing Query Text 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 TEXT REPORT
REPORT FOR INPUT RECORD:      USER      NAME=DQUSER                                                   00000603

* MEMBER-NAME *    *TYPE*    *STA*   *----------- AUTHOR -----------* *-- GROUP 1 --* *-- GROUP 2 --* *-- GROUP 3 --*
                                     *--------------------------------- QUERY-TEXT ---------------------------------*

testupshift        QUERY      PVT    DQUSER
                                     find all company
------------------------------------------------------------------------------------------------------------------------
A                  QUERY      PVT    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     TESTING
------------------------------------------------------------------------------------------------------------------------
ABC1               QUERY      PVT    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     FIND 50 PAYROLL
                                     WITH YTD-WAGES > 5000
                                     RELATED BY NUMBER TO PERSONNEL
                                     SORT BY (STATE-ADDRESS) AND (ZIP-CODE-LOC) AND PAYROLL (ACTIVITY-STATUS)
                                     PRINT PERSONNEL STATE-ADDRESS
                                     ZIP-CODE-LOC
                                     PAYROLL ACTIVITY-STATUS
                                     (YTD-COMMISSION)
                                     (YTD-WAGES)
                                     (CURRENT-RATE)
                                     (YTD-TAX)
                                     ACTIVITY-CODE
                                     NUMBER
                                     FROM PERSONNEL
                                     SOCIAL-SECURITY

Following is an explanation of the query text information found on the report:

Report Description

MEMBER-NAME

Lists the name of the member.

TYPE

Shows whether the member is a query, dialog, JCL member, PROC, or term.

STA

Shows whether the member is public (PUB) or private (PVT).

AUTHOR

Shows the name of the member's owner.

QUERY-TEXT

Gives a reproduction of each member.

GROUPS

Gives the groups associated with each Query Library Table member printed.