DB002038 identifying record not in query

Products

• IDMS
• IDMS - Database

Issue/Introduction

An SQL query is abending with DB002038 and the message identifies a record type not even in the query.

Example:

SELECT * FROM SQL."CUST-ORDER";
DB002038 T2553 NON SQL RECORD CUSTOMER, SORTED SET CALC contains element unsupported by SQL

Environment

Release : All supported releases.

Cause

The DB002038 error is valid. FILLER fields are not available to SQL and when used in calc or index keys will result in a DB002038 error.

See Metadata Mapping and DB002038.

When processing an SQL query, the optimizer loads not only the definition of the record types specifically referenced in the query, but also those that are linked to them by a network set. Therefore, it is possible to encounter this error referring to a record type not in the query. 

Resolution

Change the definition of the record identified in the DB002038 message. Make sure that any FILLER fields are renamed to have real element names. 

Additional Information

How to change a schema record definition