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

SQL/MX File Attributes

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

8-4

BLOCKSIZE

The BLOCKSIZE file attribute specifies the number of bytes in a block.

Set the BLOCKSIZE attribute for a table or index with CREATE TABLE or CREATE

INDEX statements. You cannot change the BLOCKSIZE attribute of an existing table or

index.

The default is BLOCKSIZE 4096.

number-bytes

is an integer that specifies the number of bytes in a block. Block size must be 4096

or 32768 bytes. If you specify a different block size, an error is returned.

For information on large block support and rollback of large block, see the SQL/MX

Installation and Management Guide.

BLOCKSIZE number-bytes