DB005138 Table schema.record not found in catalog

Products

• IDMS

Issue/Introduction

When trying to access  a network-defined record with SQL, receiving the below error:

SELECT RECORD FROM nonsql-schema.table-name;                            
*+ Status = -4       SQLSTATE = 42500        Messages follow:                 
*+ DB005000 T165 C0M324: Message for module IDMSOCF, SQL statement number: 1.
*+ DB005138 T165 C-4M324: Table schema.record not found in catalog 

Environment

Component: CA IDMS/DB 

Release: 19.0

Resolution

 If the original network defined record contains a hyphen in its name, and if it is  referenced as an SQL table, then it should be enclosed in double quotes .Eg: "FL-ROLLUP" 

When issuing a SELECT statement for any network record that contains a hyphen should be enclosed in double quotes when being referenced as an SQL table

• Eg: "FL-ROLLUP" if schema is defined then it should be schema."record-name"

Make sure DB name is correct

Refer to SQL Schemas for Network Databases for more information