SPDO Procedure

CLUSTER REMOVE Statement

Removes members from a cluster table.

Requirement: You must have Control access to the cluster table in order to remove a member table.
Syntax
Arguments
Details
Example

Syntax

CLUSTER REMOVE cluster-tablename MEMBER=member-name1
[, MEMBER=member-name2...];

Arguments

cluster-tablename

specifies the name of an existing cluster table.

member-name

specifies the name of one or more member tables to remove from the cluster. To specify multiple tables, use multiple MEMBER= statements.

Alias MEM=

Details

When a cluster member table is removed or replaced, users that currently have that particular cluster open for Read access will not see the change until a subsequent reopen or open of the table after the remove command has completed.
A cluster member table that has been removed from a cluster becomes visible as a separate table, but the table is in a Read-only state. If there is a need to update the table that was removed, use the CLUSTER FIX statement to restore the table to a writable state. For more information, see CLUSTER FIX Statement.

Example

This CLUSTER REMOVE statement removes member tables that contain sales information for the second half of 2014 from the cluster table Sales_History. 
cluster remove sales_history
mem=sales201407
mem=sales201408
mem=sales201409
mem=sales201410
mem=sales201411
mem=sales201412';
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017