I have a series of insert statements in my code. The table has few triggers to update last updated date and time.
Certain insertions are succeeding while other similar inserts into the table fails with DB2 SQL Error: SQLCODE=-723, SQLSTATE=09000, SQLERRMC=CMSDB.ITNPROD_AUDIT_AFTER_INSERT;-818;51003;, DRIVER=4.8.87
What could be the problem. My worry is it works for certain records whereas fails for other.