search cancel

SQLCODE -14 on a Datacom table that is actually cataloged

book

Article ID: 203025

calendar_today

Updated On:

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.