When validation routines are taken

A validation routine for a table is invoked when DB2® inserts or updates a row, even for inserts that the LOAD utility makes.

Begin program-specific programming interface information.
The routine is invoked for most delete operations, including a mass delete of all the rows of a table. If there are other exit routines, the validation routine is invoked before any edit routine, and after any date routine, time routine, or field procedure.
End program-specific programming interface information.