OMB commands for Code Template Mappings

--

Some useful OMB commands while working with CT mappings --

# Get execution units of a CT map
OMBRETRIEVE MAPPING 'MAP_NAME' GET EXECUTION_UNITS

# Create and delete execution units for a CT map
OMBALTER MAPPING 'MAP_NAME' ADD EXECUTION_UNIT 'EXECUTIONUNIT_NAME' OPERATORS ('OPERATORNAME_1','OPERATORNAME_2','..OPERATOR_NAME_N')

OMBALTER MAPPING 'MAP_NAME' DELETE EXECUTION_UNIT 'EXECUTIONUNIT_NAME'

# Create default execution units for a CT map
OMBALTER MAPPING 'MAP_NAME' SET DEFAULT_EXECUTION_UNIT


# Get and Set Code Template for an Execution unit on a CT map
OMBRETRIEVE MAPPING 'MAP_NAME' GET EXECUTION_UNIT 'EXECUTIONUNIT_NAME' \
GET REF CODE_TEMPLATE

OMBALTER MAPPING 'MAP_NAME' MODIFY EXECUTION_UNIT 'EXECUTIONUNIT_NAME' \
SET REF CODE_TEMPLATE '/PUBLIC_PROJECT/BUILT_IN_CT/DEFAULT_ORACLE_TARGET_CT'


# Get all Code Template options of an applied code template to an execution unit of
# a CT map
OMBRETRIEVE MAPPING 'MAP_NAME' GET EXECUTION_UNIT 'EXECUTIONUNIT_NAME' \
GET REF CODE_TEMPLATE OPTIONS

# Get & set code template option value of an applied code template to an execution
# unit of a CT map
OMBRETRIEVE MAPPING 'MAP_NAME' GET EXECUTION_UNIT 'EXECUTIONUNIT_NAME' \
GET REF CODE_TEMPLATE OPTIONS('OPTION_NAME')

OMBALTER MAPPING 'MAP_NAME' MODIFY EXECUTION_UNIT 'EXECUTIONUNIT_NAME' \
SET REF CODE_TEMPLATE OPTIONS('OPTION_NAME') VALUES ('NEW_VALUE')

--