SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-3
Message File
values; for tables in descending order, the last partition is the one with the lowest
range of FIRST KEY values.)

It is generally not efficient to have partitions with hundreds of extents, so you
should keep MAXEXTENTS well below the allowed maximum value. If necessary,
increase the number of partitions.
In addition, the maximum value for MAXEXTENTS might be lower in future
releases. If that occurs, existing files with higher MAXEXTENTS values will still be
valid, but those files will not be able to add additional extents beyond the current
maximum value of MAXEXTENTS.

During certain DDL operations, such as CREATE INDEX requests and ALTER
TABLE or ALTER INDEX one-way move partition requests, SQL changes the value
of MAXEXTENTS during the DDL operation and then, at the end of the operation,
resets MAXEXTENTS to the user-specified value or the actual extents allocated,
whichever is larger. If the new value exceeds the user-specified value, SQL reports
the new value in a warning message at the end of the DDL operation.
Message File
The SQL message file is a key-sequenced file that contains error messages, warning
messages, and help text for NonStop SQL/MP. The default message file,
$SYSTEM.SYSTEM.SQLMSG, contains messages and help text in U.S. English.
For information about specifying an alternate message file, see =_SQL_MSG_node
DEFINE on page Z-18.
MIN Function
MIN is a function that returns the minimum value within a set of values. The type of the
result is the type of the argument.
[ ALL ] expression
specifies an expression that indicates the set of values from which to determine a
minimum value.
The expression must include a value from each row of the result table (that is, at
least one column from the result table), and cannot include the COUNT, AVG,
MAX, or SUM functions, or another MIN function. For example,
MIN (SALARY)
MIN (PARTCOST * QTY_ORDERED)
MIN { ( [ ALL ] expression ) }
{ ( DISTINCT column ) }