ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

Datacom DATACOM - AD Ideal CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ecoMeter Server Component FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA On Demand Portal CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET 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: