Previous Topic: Purges and Stored ProceduresNext Topic: Custom SPs


Public SPs

The public SPs provided by CA DataMinder include Stub SPs and Default SPs. The Stub SP is invoked directly by the CA DataMinder infrastructure. First, it checks for a ‘well known’ Custom SP, which it invokes if one exists. If no Custom SP is defined, the Stub SP invokes the Default SP.

Public SPs

The public SPs are summarized below. For details about each public SP (for example, parameter listings), refer to comments within the SP itself. Each SP can be customized, but the SP for manual event purges does not check for pre-purge or post-purge SPs. Note also the SP naming requirements.

PUB_WGN_PURGE_STUB_1

Performs policy-determined purges.

Customizable.

Pre-purge and post-purge SPs supported.

PUB_WGN_MAN_PURGE_STUB_1

Performs policy-determined purges.

Customizable.

Pre-purge and post-purge SPs are not supported.

Oracle Public SPs

For Oracle databases, the public Stub and Default SPs are implemented as a single ‘package’. The package names are:

PUB_WGN_PURGE

Package for policy-determined purges

PUB_WGN_MAN_PURGE

Package for manually-specified purges

More information:

SP Names