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 deployment action plan.
QUOTED_STRING
Name of the action plan in a single-quoted string. It is case-insensitive. Must be unique within a project.
addActionClause
Add an action to an action plan.
QUOTED_STRING
Name of the action in a single-quoted string. It is case-insensitive. Must be unquie within an action plan.
setClause
Set the properties of an action and/or associate an object with an action.
propertiesClause
Associate a set of properties with an action.
PROPERTIES
OPERATION, which specifies the type of action to be taken. DEPLOYMENT_LOCATION, which sets the target location for a Code Template.
setReferenceClause
Associate an object with an action.
ObjType
Object type. Valid values are ADVANCED_QUEUE, CUBE, DIMENSION, EXTERNAL_TABLE, CONNECTOR, FUNCTION, MAPPING, MATERIALIZED_VIEW, PROCEDURE, PROCESS_FLOW_PACKAGE, SCHEDULABLE, SEQUENCE, TABLE, and VIEW.
QUOTED_STRING
Absolute or relative path name of an object (e.g. '/MY_PROJECT/MODULE_X/TABLE_Y'). Global objects (for example public transforms), require a relative path.
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
useClause
Currently used only in CORRECTION_SCHEMA_ACTION_PLAN.
propertyValue
Value of a property. Valid values for OPERATION are DROP, CREATE, REPLACE and UPGRADE.
