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

Problem:

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.

 

Cause:

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

TEC1617158-A.png

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.

TEC1617158-B.png

 

 

Resolution:

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.