Re: SQLSTATE 23513, get constraint name?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Take a look at the job log - there are often more messages that were 
logged before the one you are seeing. And getting an SQLSTATE, there 
will definitely be some kind of messages out there

Also check SQLCODE for a value - that value is often made part of a 
message ID - for example, if SQLCODE is 367, say, the message ID will be 
SQL0367.

But that message, if any, will be part of the job log.

This is a WAG, but based on seeing lots of messages logged in other 
error conditions for SQL.

HTH
Vern

On 12/30/2015 7:59 AM, Justin Taylor wrote:
> I have an SQLRPGLE program that's doing a SQL INSERT.  It sometimes gives me a SQLSTATE 23513 (INSERT, UPDATE, or MERGE not allowed by CHECK constraint.).  A GET DIAGNOSTICS EXCEPTION gives me the text for 23513, but I'd like to be able to programmatically retrieve the constraint name.  Any good way to do that?