OMBCREATE DEPLOYMENT_ACTION_PLAN

Purpose

Create a deployment action plan.

Prerequisites

There must be a current working project.

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.