mf_increment

Incrementing a Macro Variable

Incrementing a macro variable is fairly straightforward and can be done in several ways, for instance - a do-loop:

Retained Keys

A Retained Key is an integer used to represent a particular business key in a database table. It is useful in the following scenarios:

  1. Optimising for speed of joins
  2. Enabling business keys with null values
  3. Handling co...