Because of differences
in the load and read structures for dynamic cluster tables, the following
standard features that are available in SAS tables and SPD Server
tables are currently not supported in SPD Server 5.1:
-
You cannot directly append or update
data in a dynamic cluster table. To append new member tables to a
dynamic cluster table, create the new member tables with the data
to append, and then use the
CLUSTER ADD commands
to add the new member to the table.
-
To update an individual member
table in a dynamic cluster table, create the new member table with
the data to append, and then use the
CLUSTER REPLACE command
to replace the old member table with the new one.
-
To refresh a dynamic cluster table
by removing numerous old member tables and replacing them with new
member tables, create the new member tables with the data to append,
and then use the CLUSTER ADD and
CLUSTER REMOVE commands
to first remove and then replace the old member tables with new ones.
-
You can still use classic SPD Server
PROC SPDO CLUSTER UNDO and CLUSTER CREATE commands to refresh the
member tables in a dynamic cluster table by unbinding the dynamic
cluster table and then re-binding it back together using new member
tables, However, this process temporarily makes the cluster table
unavailable to other users, unlike the process used by the CLUSTER
REPLACE and CLUSTER REMOVE / ADD commands.
-
Record-level locking is not allowed.
-
The SPD Server backup and restore
utilities are not available.
If a task for a dynamic
cluster table requires one of these features, you should uncluster
the dynamic cluster table and create standard SPD Server tables.