SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-121
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 9-2
Controls amount of disk space allocated.
AUDITCOMPRESS on
page 9-3
Controls whether unchanged columns are included
in audit records.
BLOCKSIZE
on page 9-4 Sets size of data blocks.
CLEARONPURGE on
page 9-5
Controls disk erasure when table is dropped.
EXTENT
on page 9-6 Controls size of extents that are allocated on disk.
MAXEXTENTS on
page 9-7
Controls maximum disk space to be allocated.