Problem with errors in embedded SQL

["Jay Himes" <j@xxxxxxxxxxx>]

I am trying to insert to insert a record in a table using embedded SQL. When
there is an error I would like to return information to the caller of the
program.

The problem is when there is a constraint violation I get error messages of
SQL0530 and CPF502D as well as a SQL state of 23503 (Invalid value for
foreign key INSERT/UPDATE). However, I would like to be able to know the
name of the constraint I have violated in the program so that I can return
the information to the caller. The 2 messages have that information in them
and the SQL reference infers that it should be available in sqlerrmc (SQLERM
in RPG) from SQLCA; but sqlerrmc appears to be all blanks. Does anyone have
any idea where else the constraint violated might be accessed?

TIA,
Jay Himes