Undoing the
dynamic cluster table reverts the table back to its unbound server tables. You might want to use the CLUSTER
UNDO statement for the following reasons:
-
to refresh a dynamic cluster table
that needs many updates. Undo the cluster, and update the member tables
as needed. Then, re-create the dynamic cluster table with CLUSTER
CREATE.
-
to eliminate the cluster and return
all of the member tables to their unbound state.
Here is the PROC SPDO
code that you would use to undo cluster table Sales_History:
proc spdo library=libref;
cluster undo Sales_History;
quit;