#include <stdio.h>
DATABASE PERS = FILENAME "PERSONNEL";
main()
{
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;
}