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

book

Article ID: 39340

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update 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>

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.

<Please see attached file for image>

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.

Environment

Release:
Component: RCQ

Attachments

1558715209801000039340_sktwi1f5rjvs16tr3.png get_app
1558715207796000039340_sktwi1f5rjvs16tr2.png get_app