Cleanup when removing a record from the CreoleRuleset table.



                 Merative ™ Social Program Management is now Cúram ™ by  Merative™



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.




Document Information


More support for:
Merative Social Program Management



Software version:
7.0.0, 6.2.0, 6.1, 6.0



Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows, z/OS



Modified date:
17 June 2018