program store_with_min (input,output);
DATABASE PERS = FILENAME 'PERSONNEL';
DECLARE_VARIABLE mini SAME AS PERS.JOBS.MINIMUM_SALARY;
begin
READY PERS;
START_TRANSACTION READ_WRITE;
GET
mini = MIN J2.MINIMUM_SALARY OF J2 IN JOBS
WITH J2.WAGE_CLASS = '1';
END_GET;
STORE J IN JOBS USING
J.JOB_CODE := 'SWPR';
J.WAGE_CLASS := '1';
J.JOB_TITLE := 'Sweeper';
J.MINIMUM_SALARY := mini;
J.MAXIMUM_SALARY := 10000.00;
END_STORE;
ROLLBACK;
FINISH;
end.