SPDO Procedure
- Syntax
Procedure SyntaxPROC SPDO StatementADD ACL StatementCLUSTER ADD StatementCLUSTER CREATE StatementCLUSTER DESTROY StatementCLUSTER FIX StatementCLUSTER LIST StatementCLUSTER MODIFY StatementCLUSTER REMOVE StatementCLUSTER REPLACE StatementCLUSTER UNDO StatementCONSTRAINT ADD StatementCONSTRAINT DESCRIBE StatementCONSTRAINT REMOVE StatementDELETE ACL StatementLIST ACL StatementLIST USERS StatementLIST USERS/LOCKING StatementMODIFY ACL StatementOPER StatementREFRESH DOMAINS StatementREFRESH PARMS StatementSET ACLTYPE StatementSET ACLUSER StatementSET MODE OPER StatementSET USER StatementSET USER/LOCKING StatementSHOWLIBNAME StatementSPDSCMD StatementSPDSMAC StatementTRUNCATE Statement - Overview
- Concepts
- Examples
CLUSTER MODIFY Statement
Modifies an existing cluster table’s metadata to include minimum and maximum values for one or more columns.
| Requirement: | You must have Control access and exclusive access to the cluster table in order to execute the CLUSTER MODIFY statement. |
| See: | For detailed information about cluster tables, see “Creating and Using Dynamic Cluster Tables” in SAS Scalable Performance Data Server: User’s Guide. |
Syntax
CLUSTER MODIFY cluster-tablename MINMAXVARLIST=(var1 var2 ...);
Arguments
cluster-tablename
specifies the name of an existing cluster table.
MINMAXVARLIST= (var1 var2 ...)
specifies the name of one or more columns whose minimum and maximum values you want to add to metadata. The column names that you specify must exist in the cluster tables. The columns must not have a previous MINMAXVARLIST setting.
Details
SPD Server permits you to store the maximum and minimum values for a column in the
metadata.
The CLUSTER MODIFY statement enables you to add this metadata.
When the server runs
the CLUSTER MODIFY statement, it unclusters the cluster table and
makes the column modifications to the individual member tables. It
then re-creates the cluster table after the column modifications have
completed. If an error occurs while the CLUSTER MODIFY statement is
running, the cluster table can only be re-created manually by issuing
the CLUSTER CREATE statement.
The server performs
a full table scan to initialize the MINMAXVARLIST values in each member
table. As a result, the processing time required for the CLUSTER MODIFY
statement is directly related to the sizes of the tables that belong
to the cluster table.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017