MPE_MAXKEYVALUES

The MPE_MAXKEYVALUES table stores the current maximum surrogate / retained key value for each table configured with a retained key (see RK_UNDERLYING). It is used to generate new key values during loads.

Columns

• 🔑 KEYTABLE char(41): Base table in libref.dataset format
• KEYCOLUMN char(32): The surrogate / retained key field containing the key values
• MAX_KEY num: Integer value representing the current max RK or SK value in the KEYTABLE
• PROCESSED_DTTM num: Datetime this value was last updated