A little bit of OMB+ goes a long way

The other day I was doing some OWB work for a client. I had done some 60 mappings of the most basic kind, when I noticed that the mapping I had used as the basis (I use copy/paste a lot when working with OWB) had the 'Maximum number of errors' runtime parameter set to the ever-so-strange default value of '50'. Instead of click away through the field of mappings I had done, I came up with a tiny OMBPlus script to do the work for me. As I consulted with the client we agreed that the value should be '0' for all the mappings in the repository. So I augmented the script to loop through all the projects and all the mappings.

set projectList [OMBLIST PROJECTS]
foreach projectName $projectList {
OMBCC '$projectName'
puts "Project: $projectName"
set moduleList [OMBLIST ORACLE_MODULES]
foreach moduleName $moduleList {
puts "Process: $moduleName"
OMBCC '$moduleName'
set mappingList [OMBLIST MAPPINGS]
foreach mappingName $mappingList {
puts "Altering: $moduleName/$mappingName"
OMBALTER MAPPING '$mappingName' SET PROPERTIES (MAXIMUM_NUMBER_OF_ERRORS) VALUES ('0')
}
OMBCC '..'
}
OMBCC '..'
}
OMBCOMMIT