The following programs demonstrate the use of the MIN function in
an assignment statement. These programs:
o Store a literal value into all fields for a record in the JOBS
relation, except the field MINIMUM_SALARY
o Cross JOBS over itself
o Use the MIN function to compute the lowest salary in the
existing JOBS records for which the wage class is "1"
o Assign this computed value to the record currently being
stored
Note that the C program uses the pad_string function to read
in the values for the STORE statement. This function pads the
values stored in each field with the correct number of trailing
blanks to ensure that the length of the values stored match the
text size of the field. For more information on pad_string, see
Appendix B of the "RDML Reference Manual".
Additional Information:
explode
extract