Unsupported Features in Dynamic Cluster Tables

Because of differences in the load and read structures for dynamic cluster tables, some standard features that are available in SAS tables and SPD Server tables are currently not supported in SPD Server 4.5. These features include the following:
  • You cannot directly append data to a dynamic cluster table. To append data to a dynamic cluster table, the table must be unclustered, the data is appended to the individual unclustered files, and then the individual unclustered files must be reclustered.
  • Record-level locking is not allowed.
  • The SPD Server backup and restore utilities are not available.
  • Copying data with PROC COPY or PROC SQL is not supported.
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.