Database Guide › Infrastructure-Based Purging › Purges and Stored Procedures › SP Names

SP Names

SP names must adhere to these rules:

Stub SPs

Names must follow this pattern:

PUB_WGN_<NAME>_STUB_<INTERFACE #>

For example: PUB_WGN_PURGE_STUB_1

Default SPs

Names must follow this pattern:

PUB_WGN_<NAME>_DEF_<INTERFACE #>

For example: PUB_WGN_PURGE_DEF_1

Custom SPs

Names for custom SPs that override default SPs must follow this pattern:

PUB_WGN_<NAME>_CUSTOM_<INTERFACE #>

For example: PUB_WGN_PURGE_CUSTOM_1

Pre-purge SPs

When a purge runs, CA DataMinder checks for the following pre‑purge SP. If found, this SP is invoked before the purge:

WGN_PRE_PURGE_ACTION

Post-purge SPs

When a purge completes or terminates, CA DataMinder checks for the following post-purge SPs. If found, this SP is invoked:

WGN_POST_PURGE_ACTION

Note: SP name checking is case sensitive.