The following programs demonstrate the use of the RDB$MISSING
value expression with the STORE clause. The programs store the
specified values for the fields in the DEGREES relation. In these
programs, a value for DEGREE_FIELD is not specified; instead, the
RDB$MISSING value expression is specified. This does not actually
assign a value to the degree field; RDML marks the DEGREE_FIELD
as empty and stores nothing in this field.
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