CA Dataquery DQS805E Table not found error


Article ID: 207574


Updated On:


CA Datacom/DB


Hello - we have a Datacom DB table that does not show up in the list of tables for Dataquery. The table is cataloged in the CXX, but not available to Dataquery.

Please provide direction on how this can happen, and what we can do to resolve. 



At some point, the table or database was catalogued to the CXX, but was not Enabled.



Component : CA Dataquery for CA Datacom



The most common reason that a table is not showing up in CA Dataquery is that it was not Enabled in the Datadictionary.

Generally, we recommend that when you catalog the table or database, you also enable it. In batch, this is done with transactions like this:

//SYSIN    DD  *                                         
-USR DATACOM-INSTALL,NEWUSER                             
1000 CATALOG                                             
1000 ENABLE                                              

In DDOL, when you enter the CATALOG command, you can immediately follow it with the ENABLE command in the same format.

Once the table or database has been Enabled, it should appear in the list.


Additional Information

As always, please contact Broadcom support for CA Datacom if you have further questions.