SQLCERC value documentation

Products

• IDMS

Issue/Introduction

When an IDMS SQL statement returns an error, extra information about the error is returned in field SQLCERC in the SQLCA.

Where are the potential values of SQLCERC documented?

Environment

Release : All supported releases.

Resolution

SQLCERC values are four digit numerics. The meaning of each value can be found by looking up the message as DB00nnnn.

For example, an SQLCERC value of 1009 is described by the DB001009 message.

Additional Information

This fact is documented at SQL Status Checking and Error Handling in the Writing an SQL Program section of the IDMS documentation. Scroll down to SQLCERC.