program commit_changes (input,output);
DATABASE PERS = FILENAME 'PERSONNEL';
begin
READY PERS;
START_TRANSACTION READ_WRITE;
FOR E IN EMPLOYEES WITH E.EMPLOYEE_ID = '00193'
MODIFY E USING
E.LAST_NAME := 'Smith-Fields';
END_MODIFY;
END_FOR;
COMMIT;
FINISH;
end.