SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-160
CREATE TABLE Statement
SIMILARITY CHECK { ENABLE | DISABLE }
authorizes or prohibits similarity checks on the table. The default is SIMILARITY
CHECK DISABLE.
Tables that authorize similarity checks (SIMILARITY CHECK ENABLE) have
version 310 or later. Such tables cannot be registered in older catalogs or
accessed by older versions of NonStop SQL/MP.
attribute-spec
specifies physical file attributes for the file that holds the table. This list provides a
brief description of each attribute and its default value:
ALLOCATE Controls amount of disk space allocated. Default is to
allocate space as needed.
AUDIT Controls TMF auditing. Default is AUDIT.
AUDITCOMPRESS Controls whether unchanged columns are included in
audit records. Default is to include only changed columns.
BLOCKSIZE Sets size of data blocks. Default is 4096.
BUFFERED Turns buffering on or off. Default is on when audited, else
it is off.
CLEARONPURGE Controls disk erasure when file is dropped. Default is no
erasure.
DCOMPRESS Controls key compression in data blocks, and
compression method. Default is no compression (no
DCOMPRESS). Default compression method is 1, the
former method.
EXTENT Sets extent sizes. Default is 16 pages for the first extent,
64 for others.
FORMAT Specifies the format for the base partition of the table. To
specify the format for secondary partitions, you must
specify FORMAT in the PARTITION clauses defining each
partition. Only valid on a node running version 350 or
later.
ICOMPRESS Controls key compression in index blocks. Default is no
compression.
LOCKLENGTH Sets number of bytes in key to use for generic locks.
Default is entire key.
MAXEXTENTS Sets maximum extents. Default is 160.
NOPURGEUNTIL Sets date after which drop is allowed. Default allows
immediate drop.
RECLENGTH Sets bytes reserved for a relative-file row. Default is total
column lengths.