Which row caused insert statement to fail?

[jayvaughn]

If I do an insert into a table with a select from another table and it fails, is there a way to determine which row caused it to fail? Is there a way in embedded sql?

[JonBoy]

If I do an insert into a table with a select from another table and it fails, is there a way to determine which row caused it to fail? Is there a way in embedded sql?

GET DIAGNOSTICS includes last row and row count. I would think they should be updated at the failure point. There may be other useful values there too.

[jayvaughn]

That crossed my mind and I hope it works when I get a chance to try. Any other possibilities? Thx John boy

[tomliotta]

What was the failure? I.e., what error, SQL state/code, was returned? If you have a SELECT and the INSERT file is available, you should be able to run the SELECT with some join (or EXISTS() or whatever) to see intersections that interfere. And if it's a data mapping error, other simple tests are possible.