The DATASETS Procedure

IC REACTIVATE Statement

Reactivates a foreign key integrity constraint that is inactive.

Restriction: Must be in a MODIFY RUN group

IC REACTIVATE foreign-key-name REFERENCES libref;

Required Arguments

foreign-key-name: is the name of the foreign key to reactivate.
libref: refers to the SAS library containing the data set that contains the primary key that is referenced by the foreign key.

For example, suppose that you have a foreign key, FKEY, defined in a data set named MYLIB.MYOWN, and suppose that FKEY is linked to a primary key in the data set MAINLIB.MAIN. If the integrity constraint becomes inactive because of a processing error, you can reactivate the integrity constraint by using the following code:

proc datasets library=mylib;
   modify myown;
   ic reactivate fkey references mainlib;
run;

Chapter Contents
Previous
Next
Top of Page