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

Products

• RC Compare for DB2 for z/OS

Issue/Introduction

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. 

<Please see attached file for image>

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.

<Please see attached file for image>

 

 

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.

Environment

Release:
Component: RCQ