The default constraint mode setting for a session is DEFERRED unless you have used one of the following to specify otherwise: o SET DEFAULT CONSTRAINT MODE IMMEDIATE statement o SQLOPTIONS=(CONSTRAINTS=IMMEDIATE) qualifier on the SQL precompiler command line o CONSTRAINTS=IMMEDIATE qualifier on the SQL module language command line