Receiving message RQ012E TABLE SELECTED CONTAINS NO ENTRIES during table list within CA RC/Query even though object exists.

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


Attempting a table list within CA RC/Query for DB2 for z/OS (RCQ) and receiving message, RQ012E - TABLE SELECTED CONTAINS NO ENTRIES, even though object exists.  The same table list query returns the expected results for a different user.



The most likely cause of the RQ012E message within RCQ is that one of the header fields is not cleared completely. 


Notice the > at the end of Table Name and Qualifier, press PF11 to show the rest of the field to the right.  Check if there are

extraneous characters and remove them.  The <> indicates the end of the field.





When the RQ012E message is encountered issue the SQL command from the COMMAND ===> line.  Inspect the WHERE clause content in the SQL returned.  Clear any of the header fields such as Table Name ===> or Creator ===> where appropriate depending on the results of the SQL command.