Handling Update Errors in Proc SQL

« Back to Glossary Index

While updating or inserting rows in a table, you might receive an error message that the update or insert cannot be performed.

Using the UNDO_POLICY= option, you can control whether the changes have already been made and become permanent.

The UNDO _POLICY= option in the PROC SQL and RESET statements determines how PROC SQL handles the rows that have been inserted or updated by the current INSERT or UPDATE statement up to the point of error.

  • UNDO_POLICY=REQUIRED – It is the default. It undoes all updates or inserts up to the point of error.
  • UNDO_POLICY=NONE – It does not undo any updates or inserts.
  • UNDO_POLICY=OPTIONAL – It undoes any updates or inserts that it can undo reliably.
« Back to Glossary Index