SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-30
FORMAT File Attribute
FORMAT File Attribute
FORMAT is a file attribute that specifies the format of a partition. A Format 1 partition is
limited to one gigabyte. A Format 2 partition might grow to one terabyte, or the size of
a single disk volume.
If the table’s PARTITION ARRAY VALUE has been set to STANDARD or EXTENDED,
the default format is FORMAT 1. If the table’s PARTITION ARRAY VALUE has been
set to FORMAT2ENABLED, the default format is FORMAT 2.
Considerations—FORMAT

FORMAT specifies the format for the base partition of the table or index. To specify
the format for secondary partitions, you must specify FORMAT in the PARTITION
clauses defining each partition.

If you specify FORMAT 2 and do not use the PARTITION ARRAY clause, the
PARTITION ARRAY is set to FORMAT2ENABLED.

Only key-sequenced tables can be Format 2 enabled.

To create Format 2 partitions, a file’s PARTITION ARRAY VALUE must be
FORMAT2ENABLED.
FREE RESOURCES Statement
FREE RESOURCES is a DCL statement that releases locks, closes cursors, and
flushes insert/update buffers for audited and, optionally, nonaudited objects.
The exact effect of FREE RESOURCES depends on how the locks were acquired,
whether the affected objects are audited or nonaudited, and whether a transaction is in
progress, as explained later in this entry.
You can use FREE RESOURCES instead of explicit UNLOCK TABLE or CLOSE
CURSOR statements. COMMIT WORK and ROLLBACK WORK automatically perform
all the operations of FREE RESOURCES.
AUDITONLY
directs SQL to retain existing locks on nonaudited objects.
CLOSE TABLES
directs SQL to close tables. Otherwise, users or programs without access
privileges can open them.
{ FORMAT 1 | FORMAT 2 }
FREE RESOURCES [ AUDITONLY ] | [ CLOSE TABLES ]