The following programs demonstrate the use of the commit
statement to make permanent changes to a field value in a
database. These programs:
o Use a record selection expression to find an employee in the
EMPLOYEES relation with the ID number "00193"
o Use a MODIFY statement to change the field value of
E.LAST_NAME for this employee
Although this change is written to the database at the time of
the MODIFY, the change is not permanent until the programs issue
a COMMIT statement. After the programs issue the COMMIT statement
the old value for E.LAST_NAME is not available.
The C example uses the function pad_string to pad the name
"Smith-Fields" with blanks. Blanks are appended to the name so
that the length of the name matches the spaces reserved for it in
the database definition for LAST_NAME.
Additional Information:
explode
extract