SQLCODE -14 on a Datacom table that is actually cataloged

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

Running a simple SQL query on a Datacom table:

SELECT * FROM SYSUSR.MY_TABLE

It fails due to:

SQLCODE = -14, SQLSTATE=42704                                   
MESSAGE = TABLE/VIEW DOES NOT EXIST: MY_TABLE AUTHID: SYSUSR

However, a CXX report shows the table as correctly cataloged and loaded.

Environment

Release : 15.1

Component : CA DATACOM SQL

Cause

On DataDictionary, the PROD version of the database structure has been accidentally overlaid by an older version that does not contain the table getting the error. SQL uses DataDictionary and DDD definitions also, not only the CXX ones.

Resolution

Correct the DataDictionary to use the right database PROD version.