SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-85
Syntax Description of CREATE TABLE
subvolume
is the name of the schema subvolume for the schema in which the table is
being created.
Follow these guidelines when using SQL/MX subvolume names:
•
The name must begin with the letters ZSD, followed by a letter, not a
digit (for example, ZSDa, not ZSD2).
•
The name must be exactly eight characters long.
file-name
is a Guardian file name. file-name names must be eight characters in
length and must end with the digits “00” (zero zero.)
Any Guardian file name you specify must match the designated schema
subvolume name for the schema in which the object is being created.
Otherwise, NonStop SQL/MX returns an error.
partition-name
is an SQL identifier for a partition.
partn-file-option is an SQL/MX extension.
See PARTITION Clause on page 7-5.
ATTRIBUTE[S] attribute [,attribute]...
specifies attributes of the physical file that holds the table. In an ATTRIBUTES
clause that is within a PARTITION clause, you must separate attributes with a
space. In ATTRIBUTES clauses in other places, you can separate attributes
with either a space or a comma. You can specify these file attributes:
If you use the LIKE specification and you do not specify ATTRIBUTE[S]
attribute [,attribute]..., NonStop SQL/MX uses the attributes
associated with the source-table.
ALLOCATE/DEALLOCATE
on page 8-2
Controls amount of disk space allocated.
AUDITCOMPRESS
on
page 8-3
Controls whether unchanged columns are included
in audit records.
BLOCKSIZE
on page 8-4 Sets size of data blocks. 4096 is the only supported
value.
CLEARONPURGE on
page 8-5
Controls disk erasure when table is dropped.
EXTENT on page 8-6 Controls size of extents that are allocated on disk.
MAXEXTENTS on
page 8-7
Controls maximum disk space to be allocated.