#include <stdio.h>
DATABASE PERS = FILENAME "PERSONNEL";
DECLARE_VARIABLE min SAME AS PERS.JOBS.MINIMUM_SALARY;
extern void pad_string();
main()
{
READY PERS;
START_TRANSACTION READ_WRITE;
GET
min = MIN J2.MINIMUM_SALARY OF J2 IN JOBS
WITH J2.WAGE_CLASS = "1";
END_GET;
STORE J IN JOBS USING
pad_string ("SWPR", J.JOB_CODE, sizeof(J.JOB_CODE));
pad_string ("1", J.WAGE_CLASS, sizeof(J.WAGE_CLASS));
pad_string ("Sweeper", J.JOB_TITLE, sizeof(J.JOB_TITLE));
J.MAXIMUM_SALARY = 10000.00;
J.MINIMUM_SALARY = min;
END_STORE;
ROLLBACK;
FINISH;
}