SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX File Attributes

HP NonStop SQL/MX Reference Manual—540440-003

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

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

BLOCKSIZE number-bytes