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.