NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
M-3
Message File
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 then-
current maximum value of MAXEXTENTS.
•
MAXEXTENTS value during DDL operations
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.
See =_SQL_MSG_
node DEFINE on page Z-16 for information about specifying an
alternate message file.
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)
ALL is an optional keyword that does not change the meaning of the clause. SQL
uses all rows (whether or not you specify ALL) unless you use the DISTINCT
clause, described next.
MIN { ( [ ALL ] expression ) }
{ ( DISTINCT column ) }