Adding Members to a Dynamic Cluster Table

Suppose that six months later, you have six additional server tables and want to add them to the dynamic cluster table. The tables have table and column attributes that are identical to the existing member tables in the cluster. To add the tables to the original cluster table, you use the CLUSTER ADD statement. The CLUSTER ADD statement also takes arguments cluster-name and MEMBER= (MEM=). The following example shows how to issue the CLUSTER ADD statement in PROC SPDO. The PROC SPDO LIBRARY= argument specifies a libref that identifies the target domain.

proc spdo library=libref;
   cluster add Sales_History
      mem=sales201501
      mem=sales201502
      mem=sales201503
      mem=sales201504
      mem=sales201505
      mem=sales201506;
quit;

Tables that are added with the CLUSTER ADD statement are appended to the end of the member table list. Adding Member Tables to a Dynamic Cluster Table illustrates the process of adding tables to a cluster.

The examples at the end of this chapter contain more extensive code examples of adding to a dynamic cluster table.