ASAP 2.8 Server Manual

ASAP Conversational Interface Commands
HP NonStop ASAP Server Manual522303-007
6-106
SET Command
* Decimal integers representing byte values from 0 through 255,
enclosed in brackets (for example, [10, 13, 129]). You can use this
format to represent any partial key value, on a byte-by-byte basis.
* A mixture of quoted character strings and decimal integer byte values
enclosed in brackets (for example, [10, "ab", 13, 129]). You can use
this format to represent any partial key value, with the quoted strings
simplifying entry of printable alpha-numeric characters.
system-number
a valid NonStop OS system number from 0 through 255. The purpose
of this value is to simplify specifying partial key values that utilize the
system number portion of the ASAP record key. This value, if supplied,
is prefixed to any supplied key-value to define the actual key used to
partition the database.
ext-value
an integer value from 1 through 65535 for Format 1 files, or 1 through
512,000,000 for Format 2 files. It specifies the number of pages in the
extent. This value can be rounded up to an even number when the
partition is created.
maxext-value
an integer value from 16 through 978, that specifies the maximum
number of extents in the partition.
volume-name
the name of the NonStop OS volume on which the partition will reside.
reset-desc.
RESET
resets all partitioning attributes for all entities, including the default settings.
{ entity | DEFAULT } RESET
resets all partitioning attributes for the specified entity, or the default
settings if you specify DEFAULT.
{ entity | DEFAULT } { part-num | ALL } RESET
resets the partitioning attributes of the specified partition of the specified
entity, or default settings. To reset the partitioning attributes of all partitions
for the specified entity, use ALL.