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.
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* |
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* |
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. |