*COMMIT_MAX_MEMBERS

Allowed uses: By Commit, MDX

*COMMIT_MAXMEMBERS

Allows you to modify the behavior of the XDIM_MAXMEMBERS option so that commits are performed after each individual query rather than all at once at the end of the loop of queries.

When the instruction XDIM_MAXMEMBERS is used in MDX-type rules, the rules query is broken into as many queries as required to accommodate all members to process. However, all resulting records are committed to the database in one lump at the end of the loop of queries, and not after each query. There may be cases where this is not desired (for example for memory limitations), and it may be preferable to perform a commit to the database after each individual query.

You must insert this instruction inside an *XDIM_MAXMEMBERS instruction. See *XDIM_MAXMEMBERS for more information.