IF (EXISTS(Select * from sys.systrigger where LCase(trigger_name) = LCase('Trig_LogFile_PoslData')))
THEN Drop trigger Trig_LogFile_PoslData
END IF

GO

create trigger Trig_LogFile_PoslData before insert,update order 1 on
DBA.LogFile
referencing old as old_ new as new_
for each row
begin
  if New_.PoslData is null then
    set New_.PoslData = current timestamp
  end if;
end
//[14 Aug 2002]