SQLCODE -14 (TABLE/VIEW DOES NOT EXIST) in Datacom SQL

Products

• Datacom

Issue/Introduction

A Datacom job fails with the following error messages:

• DB21012E ---- PREPARE STATEMENT FAILED (QHOST)
• TABLE/VIEW DOES NOT EXIST
• SQLCA-SQLCODE = -14
• SQLCA-SQLSTATE = 42704

Despite verifying that the SQL name and AUTHID match the table definition, the job fails to locate the table.

Environment

Z/OS

Datacom SQL all versions

Cause

CXX and Datadictionary ( DD and DDD) are out of sync.

Resolution

CATALOG the database . This process updates the CXX, DD, and DDD, ensuring all definitions are synchronized.