program multiply (input,output);
DATABASE PERS = FILENAME 'PERSONNEL';
begin
READY PERS;
START_TRANSACTION READ_WRITE;
FOR SH IN SALARY_HISTORY
WITH SH.EMPLOYEE_ID = '00164'
AND SH.SALARY_END MISSING
MODIFY SH USING
SH.SALARY_AMOUNT := SH.SALARY_AMOUNT * 1.1;
END_MODIFY;
END_FOR;
ROLLBACK;
FINISH;
end.