SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-83
CONTROL TABLE Directive
SEQUENTIAL BLOCKSPLIT [ FOR INSERT ] { ON | ENABLE }
specifies the method of splitting blocks when an INSERT requires a block split:
The default is SEQUENTIAL BLOCKSPLIT ENABLE.
The SEQUENTIAL BLOCKSPLIT option is similar to the SETMODE 91,3 option
available for Enscribe files, except that it applies only to tables and views, not to
indexes.
{ SKIP | STOP AT } UNAVAILABLE PARTITION
controls whether SQL continues to process a query when a partition required by
the access plan of the query is unavailable.
This option applies to both partitioned tables and partitioned indexes, but affects
only the main query in a SELECT statement without an INTO clause. (SQL always
stops processing and returns an error when a required partition is unavailable for a
subquery, a SELECT statement in the search condition of an UPDATE or DELETE
statement, a SELECT with an INTO clause, or any other DML or DDL statement.)
The default is STOP AT UNAVAILABLE PARTITION.
Any of these conditions make a partition unavailable:

The volume is not available (error 66)

The file is bad (error 59)

No more opens are permitted on the volume (error 61)

A path or network error occurs (errors 200-255)
ON splits blocks as if inserts are sequential
ENABLE selects the block split algorithm depending on whether sequential
inserts are detected
Note. Using SEQUENTIAL BLOCKSPLIT ON when inserts are not actually sequential and
in increasing order by primary key (or when intervening records exists in blocks where
inserts occur) can waste substantial disk space.
Use SEQUENTIAL BLOCKSPLIT ENABLE unless you are extremely knowledgeable
about the way block splits are handled and absolutely certain that your table will receive a
series of sequential inserts that the disk process can not recognize as sequential. (For a
discussion of such a case, see information about specifying the sequential blocksplit
algorithm on page C-87
.)
SKIP If a required partition is unavailable, issue warning 8239 (Partition
was skipped), open the next partition, and return the next row that
satisfies the search conditions of the query.
STOP AT If a required partition is unavailable, return an error and stop
processing the query.