Stored procedures

The i2 Analyze deletion-by-rule functions depend upon a set of standard stored procedures. You can use these procedures to manage deletion rules and create deletion jobs.

The procedures that are available are described in the following table. An asterisk indicates a mandatory parameter.
Table 1. Deletion by rule: stored procedures
Procedure Parameters Description
IS_Public.Automate_Deletion_Rule RULE_NAME*

Set automated to Y for the named rule to be included in the scheduled automatic creation of deletion jobs.

Deletion-by-rule jobs are placed in the queue of deletion jobs to be run in sequence.

IS_Public.Create_Deletion_Rule

RULE_NAME*
VIEW_NAME*
CONDITIONS

Convert the SQL conditions and named view to a rule that is ready for deletion job creation.

CAUTION: When a job is created from a rule that has no conditions, it deletes every record in the view.
IS_Public.Delete_Deletion_Rule RULE_NAME* Delete the named rule.
IS_Public.Disable_Deletion_Rule RULE_NAME*

Set the automated parameter to N for the rule to be excluded from the scheduled automatic creation of deletion jobs.

The rule can be used for manual deletion only.

IS_Public.Create_Deletion_Job

RULE_NAME*

Create a deletion job that is based on the named rule. This procedure can be run for the rule when the value of automated is Y or N. The deletion-by-rule job is placed in the queue of deletion jobs to be run.

IS_Public.Update_Deletion_Rule

RULE_NAME*
VIEW_NAME*
CONDITIONS

Update the named rule by revising the original VIEW_NAME or CONDITIONS.
IS_Public.Update_Deletion_Schedule SCHEDULE* Update the job creation schedule. For more information about the schedule format, see Changing the automated job creation schedule.
IS_Public.Validate_Deletion_Rule RULE_NAME*

Report on the SQL Results tab any SQL errors that are found associated with the SQL conditions of the named rule.

The report contains results by MESSAGE, SQLCODE, and SQLSTATE values.