CREATE TABLE table_for_audit_of_deletes
	(
	username character( 30 ) NOT NULL,
	hostname character( 20 ),
	sqls lvarchar,
	time datetime YEAR TO FRACTION NOT NULL
	)
	EXTENT SIZE  32  NEXT SIZE  32 
	LOCK MODE PAGE;

CREATE TRIGGER trigger_for_audit_of_deletes delete on table_which_under_control
	before (
INSERT INTO table_for_audit_of_deletes (username, hostname, sqls, time)
SELECT username, hostname, sqs_statement,  DBINFO('utc_to_datetime', sh_curtime)
FROM    sysmaster:syssessions, sysmaster:syssqlstat, sysmaster:sysshmvals
WHERE   sid = sqs_sessionid
AND UPPER(sqs_statement) like 'DELETE%'
AND username = USER
);