SQL$HELP72.HLB  —  ALTER  STORAGE_MAP, Arguments  store-clause
    A new storage map definition that replaces the existing storage
    map. The store-clause allows you to specify which storage area
    files will be used to store rows from the table. Note that:

    o  All rows of a table can be associated with a single storage
       area.

    o  Rows of a table can be distributed among several storage
       areas.

    o  Rows of a table can be systematically distributed
       (horizontally partitioned) among several storage areas by
       specifying upper limits on the values for a column in a
       particular storage area.

    The store-clause specifies only how you want to associate rows
    with areas and not the manner in which rows are assigned to pages
    within an area.

    See the CREATE STORAGE_MAP statement for a description of the
    syntax for the store-clause. However, the effect of the clause
    in the ALTER STORAGE MAP statement depends on how you change the
    existing storage map.
Close Help