SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-159
CREATE TABLE Statement
PARTITION ARRAY { STANDARD | EXTENDED | FORMAT2ENABLED }
specifies the type of partition array created for the underlying table and all
associated indexes:
The size of the partition array affects how many partitions can be created for a
table and its indexes. It also affects how many indexes can be created against the
base table. An extended and Format 2 enabled partition array supports a larger
number of indexes and table and index partitions.
PARTITION ARRAY applies to partitions created later for a table, even if the table
is not initially partitioned. To change the setting for a table, use the ALTER TABLE
command.
You can use the PARTITION ARRAY clause in SQLCI or in dynamic SQL
statements. To check the value of PARTITION ARRAY, use the FILEINFO DETAIL
command.
Tables and indexes using extended arrays require a version 320 or later catalog.
DML and DDL statements on tables and indexes with extended arrays can be
performed only from nodes running version 320 or later of NonStop SQL/MP. If
these conditions are not met, SQL returns an error.
Tables and indexes using Format 2 enabled arrays require a version 350 or later
catalog. DML and DDL statements on tables and indexes with Format 2 enabled
arrays can be performed only from nodes running version 350 or later of NonStop
SQL/MP. If these conditions are not met, SQL returns an error.
You can set the partition array value to FORMAT2ENABLED by either specifying
PARTITION ARRAY FORMAT2ENABLED or by specifying FORMAT 2 for an
individual partition.
If you omit this clause, the default PARTITION ARRAY type is STANDARD for all
table types.
SECURE "rwep"
specifies the security for the table. For more information, see Security on
page S-11. The default is the security of the user who executes the CREATE
TABLE.
EXTENDED specifies the extended partition array available for
versions 320 and later of NonStop SQL/MP
STANDARD specifies the type of array used by default by NonStop
SQL/MP
FORMAT2ENABLED specifies a Format 2 enabled table that can contain any
combination of Format 1 or Format 2 partitions.
FORMAT2ENABLED implies that the partition array has
the same limits as a file with EXTENDED partition array.
Only valid on a node running version 350 or later.