I would like to signal a warning from a trigger but what I get it's
always and error instead of a warning. Is it possible to signal a
warning from a trigger ?
.....
SIGNAL SQLSTATE '01ZZZ' ('RICHIESTO UN TEST REPORT');
.....
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0723N An error occurred in a triggered SQL statement in trigger
"MAXI.INS_DOCUMENTO". Information returned for the error includes
SQLCODE
"-435", SQLSTATE "428B3" and message tokens "01ZZZ". SQLSTATE=09000