Hi all,

I'm wanting to capture a error message text such as:

SQL0530N The insert or update value of the FOREIGN KEY
"TST01.TEST_RETURNS.F_EXAM_TYPE" is not equal to any value of the
parent key of the parent table. SQLSTATE=23503

in a sql stored procedure continue handler so it can be logged as to why it couldn't be processed and the next record processed.

I've got code that records the sqlcode or sqlstate for logging. Whilst the sqlcode/sqlstate indicate that there has been a FK violation, it doesn't indicate on what FK. Important on tables with lots of FKs!


thanks

What DB2 version and OS?

This is for V8 and higher for LUW:

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
GET DIAGNOSTICS EXCEPTION 1 MESSAGE_TEXT_OUT = MESSAGE_TEXT;

END;


HTH

Andy

Hi Andy,

thanks for your quick response! Just what I was looking for. It is simple when you know how - I just didn't know what I should have been looking for.