CREATE TABLE appuser.event
(
  obj_id bigint NOT NULL, -- Internal ID: Internal session ID
  event_type smallint NOT NULL DEFAULT 0, -- Event Type: Type of event
  peers integer NOT NULL, 
  event_time timestamp without time zone NOT NULL, -- Event Time: Time when Policy Engine should be triggered
  rowid bigserial NOT NULL,
)

---TimesTen
DELETE FIRST 1 FROM event evnt 
WHERE event_time < TT_SYSDATE 
  AND peers=:peers 
RETURNING 
  obj_id, event_type 
INTO 
  :obj_id, :event_type

---Postgresql
DELETE FROM event 
WHERE rowid IN (SELECT rowid FROM event WHERE 
  event_time < now()
  AND peers=$1
LIMIT 1) 
RETURNING 
   obj_id, event_type