SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-110
Syntax Description of CREATE TABLE
environment or at the system level) and your environment does not have a
=_DEFAULTS value, the CREATE statement will fail with an error.
You can locate more than one partition of a table on a single disk volume.
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.

The subvolume 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.
file-name
is a Guardian file name. file-name names must be eight characters long
and must end with the digits “00” (zero zero).
partition-name
is an SQL identifier for a partition.
partn-file-option is an SQL/MX extension.
See PARTITION Clause on page 7-6.
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:
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.
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.