An SQL query is abending with DB002038 and the message identifies a record type not even in the query.
SELECT * FROM SQL."CUST-ORDER";
DB002038 T2553 NON SQL RECORD CUSTOMER, SORTED SET CALC contains element unsupported by SQL
Release : All supported releases.
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.
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.
Change the definition of the record identified in the DB002038 message. Make sure that any FILLER fields are renamed to have real element names.