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

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

book

Article ID: 39340

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

Attempting a table list within RC/Query for Db2 for z/OS (RCQ) and receiving the following message even though objects exists:
RQ012E - TABLE SELECTED CONTAINS NO ENTRIES

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.

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.