I'm running 7.6.0.1 where I have a custom application with custom database object and index to enforce uniqueness in an attribute.

When I try to save a record that would violate the unique index, the error message is the cryptic default:

"BMXAA4211E - Database error number 1 has occurred when operating on CRROOMS : Crroomsid=76,413. Report the error to the owner of the deployment. More information"

How can I customize the message for this error in this application to be more user friendly? I'd like to say which field(s) are causing the error and why.

I see how to modify the messages, but I assume that would change the message everywhere that uses that that group and key.

In automation scripts I don't see how I can either intercept that error message or check for an index violation.

This product forum is intended for client to client collaboration.

If you want to engage IBM Support, you should open a support case: https://www.ibm.com/mysupport/s/createrecord/NewCase