SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
M-2
Example—MAX

MAX is evaluated after eliminating all null values from the aggregate set. If the
result set is empty, MAX returns a null value.

A host variable that receives the result of the MAX function must have an indicator
variable to handle a possible null value. (For more information about using
indicator variables, see the SQL/MP programming manual for your host language.)
Example—MAX
To display the maximum value in the SALARY column, type:
>>SELECT MAX (SALARY) FROM PERSNL.EMPLOYEE;
(EXPR)
------------
175500.00
--- 1 row(s) selected.
MAXEXTENTS File Attribute
MAXEXTENTS is a file attribute that specifies the maximum number of extents that
can be allocated for an unpartitioned file or for each partition of a partitioned file.
MAXEXTENTS applies to key-sequenced, relative, and entry-sequenced tables and to
indexes.
num-extents
is an integer from 1 to 959 (but not less than the number of extents currently
allocated for the file) that specifies the maximum number of extents that can be
allocated. Format 1 partitions allow MAXEXTENTS up to 944. Format 2 partitions
allow MAXEXTENTS up to 919. These limits are enforced by DP2 when you
attempt to allocate the 945th (Format 1) or 920th (Format 2) extent.
The default is MAXEXTENTS 160.
SQL catalog manager enforces the following limits when the define
=_SQL_LATEST_MAXEXTENTS is added:

For FORMAT 1 partitions (whether primary or secondary), maximum allowed
MAXEXTENTS limit is 944.

For FORMAT 2 partitions (whether primary or secondary), maximum allowed
MAXEXTENTS limit is 919.
Considerations—MAXEXTENTS

You can alter MAXEXTENTS for any partition of an index or a key-sequenced table
but only for the last partition of a relative or entry-sequenced table. (For tables in
ascending order, the last partition is the one with the highest range of FIRST KEY
MAXEXTENTS num-extents