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

Document ID : KB000019998
Last Modified Date : 14/02/2018
Show Technical Document Details

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.