Prerequisites
In the context of a data profile. First do OMBCREATE DATA_RULE, and OMBALTER TABLE 'T' ADD DATA_RULE_USAGE, on the profile tables that will be mapped.
Syntax
CreateActionPlanCommand = ( OMBCREATE TRANSIENT ( ( DEPLOYMENT_ACTION_PLAN
| ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN |
CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" { "addActionClause" }
)
addActionClause = ADD ACTION "QUOTED_STRING" [ SET "setClause" ]
setClause = ( "propertiesClause" [ SET "setReferenceClause" ] ) |
"setReferenceClause"
propertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "("
"propertyValueList" ")"
setReferenceClause = ( REF | REFERENCE ) "ObjType" "QUOTED_STRING" {
"useClause" }
propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
propertyValueList = "propertyValue" { "," "propertyValue" }
useClause = USE DATA_RULE_USAGE "QUOTED_STRING"
propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" |
"FLOATING_POINT_LITERAL" )
Parameters
CreateActionPlanCommand
Create a correcton schmema action plan.
QUOTED_STRING
Action plan name.
addActionClause
Add an action to an action plan.
QUOTED_STRING
Action name.
setClause
Set the properties of an action and/or associate an object with an action.
propertiesClause
Set the properties and/or associate/disassociate an object with an action.
setReferenceClause
Associate an object with an action.
ObjType
Object type. The only valid value is DATA_PROFILE_TABLE.
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
useClause
Use data rule in construction of correction schema.
QUOTED_STRING
Name of data rule usage.
propertyValue
Value of a property.
