Cleanup when removing a record from the CreoleRuleset table.
Question & Answer
Do I have to do any cleanup if I remove a record from the CreoleRuleset table?
Yes. Otherwise, you may experience an error the next time you use the creole.upload.rulesets target.
This is because the rule structures defined in the CreoleRuleset table get denormalised into a number of other tables - CreoleRuleClass, creoleRuleAttribute, creoleAttributeAvailability, etc - and these tables may contain records which still reference the records deleted from CreoleRuleset.
The attached SQL script finds and cleans up these unused records.
More support for:
Merative Social Program Management
7.0.0, 6.2.0, 6.1, 6.0
AIX, HP-UX, Linux, Solaris, Windows, z/OS
17 June 2018