SQL$HELP72.HLB  —  CREATE  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 are. For multicolumn index keys,
    specify a literal value for each column.

    The number of literals in the list must be the same as the number
    of columns in the USING clause. Repeat this clause to partition
    the entries of an index among multiple storage areas. 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.

    If you are creating a multisegmented index using multisegmented
    keys and the STORE USING . . . WITH LIMIT clause, and if the
    values for the first key are all the same, then set the limit
    for the first key at that value. This ensures that the value of
    the second key determines the storage area in which each row is
    stored.
Close Help