SQL$HELP72.HLB  —  ALTER  INDEX  Arguments  WITH_LIMIT_OF
    Specifies the highest value for the index key that resides in a
    particular storage area if ASCENDING is defined. If DESCENDING
    is defined, the lowest value is specified for the index key
    that resides in a particular storage area. For multicolumn index
    keys, specify a literal value for each column listed in the USING
    clause.

    The WITH LIMIT OF clause must specify a new unique set of values
    for the partition. The number of literals in the list must be
    the same as the number of columns in the USING clause. The data
    type of the literals must agree with the data type of the column.
    For character columns, enclose the literals in single quotation
    marks.
Close Help