The following programs demonstrate the use of the context
variable "CS" for the CURRENT_SALARY view. These programs:
o Use "CS" to qualify field names in the record selection
expression, printf, and WRITELN statement
o Print the employee ID of all the employees who earn more than
forty thousand dollars
1 – C Example
#include <stdio.h>
DATABASE PERS = FILENAME "PERSONNEL";
main()
{
READY PERS;
START_TRANSACTION READ_ONLY;
FOR CS IN CURRENT_SALARY WITH CS.SALARY_AMOUNT > 40000.00
printf ("%s\n",CS.EMPLOYEE_ID);
END_FOR;
COMMIT;
FINISH;
}
2 – Pascal Example
program context_var (input,output);
DATABASE PERS = FILENAME 'PERSONNEL';
begin
READY PERS;
START_TRANSACTION READ_ONLY;
FOR CS IN CURRENT_SALARY WITH CS.SALARY_AMOUNT > 40000.00
writeln (CS.EMPLOYEE_ID);
END_FOR;
COMMIT;
FINISH;
end.