Member Table Requirements for Creating Dynamic Cluster Tables

Overview of Table Requirements

When you create a dynamic cluster table, all of the member tables must have matching table, variable, and index attributes. If there are attribute mismatches, the dynamic cluster table creation fails, and SPD Server displays the following error message:

ERROR: Member table not compatible with other cluster members. Compare CONTENTS.

A more detailed error message is written to the SPD Server log. The SPD Server log lists which attribute is mismatched in the member table. The following lists specify the member table attributes that must match for SPD Server to successfully create a dynamic cluster table.

Table Attributes

The following table attributes must match in all member tables to successfully create a dynamic cluster table:

IDXSEGSIZE

index segment size

OBSLEN

observation record length

NVAR

number of columns

NINDEXES

number of indexes

DSORG

data set organization

SEMTYPE

data set semantic type

DSTYPE

SAS data set type

LOCALE

creation locale

LANG

data set language tag

LTYPE

data set language type tag

FLAGS

compressed data set

encrypted data set

backup data set

NLS variables in data set

MINMAXVARLIST variables in data set

SAS encryption password in data set

SASPW

SAS encryption password

DS_ROLE

data set option for ROLE

ENCODING_CEI

encoding CEI for NLS (for compressed tables)

DISKCOMP

compression algorithm

IOBLOCKSIZE

I/O block size

IOBLOCKFACTOR

I/O block factor

Variable Attributes

The following variable attributes must match in all member tables to successfully create a dynamic cluster table:

NAME

variable name

LABEL

variable label

NFORM

variable format

NIFORM

variable informat

NPOS

variable offset in record

NVARO

variable number in record

NLNG

variable length

NPREC

variable precision

FLAGS

NLS encoding supported

MINMAXVARLIST variable

NFL

format length

NFD

format decimal places

NIFL

informat length

NIFD

informat precision

NSCALE

scale for fixed-point decimal

NTATTR

variable type attributes

TYPE

variable type

SUBTYPE

variable subtype

SORT

variable sorted status

NTYPE2

variable extended type code

Index Attributes

The following index attributes must match in all member tables to successfully create a dynamic cluster table:

NAME

index name

TYPE

index type

KEYFLAGS

unique index

nomiss index

LENGTH

index length

NVAR

number of variables in index

NVAR0

variable number in index