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.
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.