How to suppress an EXPORT report when submitting from CA Dataquery batch online?

book

Article ID: 20119

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA Ideal CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

Description:

You run the DQBATCH EXPORT query in batch and do not want to have the query execution report .

Solution:

On panel DQEN0 , Batch online submit panel , place X in Suppress Report for a basic query , do not select any other option and select EXPORT to a sequential file.


--------------------------------------------------------------------------DQEN0
DATAQUERY:  BATCH EXECUTION                                                   
-------------------------------------------------------------------------------
Enter name of query to submit:           ACTIVE-QUERY                          
Select the type of execution:            X  Immediate                          
                                         _  Defer execution until time __ : __
Enter the name of the JCL member to use: $$DQJCL                               
Enter nonblank to use JCL for deferred:  _                                     
Select the report type:                                                        
             Detail and totals           _  When/do column functions only     
          _  Detail only (no totals)     _  No detail (totals and when/do)    
          _  Totals only (summary)       x  Suppress report                    
To export print data to a sequential file, select output record type:         
          _  Variable comma separated    x  Fixed length record               
For variable, enter name of output set   _______________                       
For variable, select output type:        _  Detail                             
                                         _  Totals 

Environment

Release: DATABB00200-14-Datacom/AD
Component: