Can you use the CA Datacom Dataquery DRAW command in DQRY against the AUTOSCOPE DBID'S 1018, 1019 or 1020?

book

Article ID: 19998

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:

When doing a Dataquery DRAW command against a AUTOCOLLECT table I am getting the following error:

DQ299E - TABLE CAN'T BE DISPLAYED - IT IS NOT A TABLE THAT YOU MAY ACCESS S_MUF_RETURN_CODES

Solution:

The SQL AUTHID for the AUTOSCOPE tables is "AUTOCOLLECT". So, to inquire against any AUTOSCOPE tables such as S_MUF_RETURN_CODES, you need to update your CA Dataquery PROFILE in DQRY to add AUTOCOLLECT into SQL AUTHORIZATION ID.

Environment

Release: DATABB00200-14-Datacom/AD
Component: