Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBREDEFINE ASSOCIATION_DEFINITION

Purpose

To redefine an association between two classes (types).

Prerequisites

Association definition to be redefined should already exist. This command can be executed for any association definition regardless of current context. User must have CREATE_EXTENSIONMODEL system privilege and has to be connected in single user mode to run this command.

Syntax

parseRedefineAssociationCommand =  OMBREDEFINE ASSOCIATION_DEFINITION 
          "QUOTED_STRING" [ ( ON | OF ) "modelClause" ] ( RENAME TO 
          "QUOTED_STRING" | "setAssociationDefinitionPropertiesClause" | ( 
          "modifyDependencyDefinitionClause" | 
          "deleteDependencyDefinitionClause" | "addDependencyDefinitionClause" 
          )+ )
     modelClause =  ( MODEL "QUOTED_STRING" | PLATFORM "QUOTED_STRING" | 
          CONFIGURATION_TEMPLATE "QUOTED_STRING" ( ON | OF ) PLATFORM 
          "QUOTED_STRING" )
     setAssociationDefinitionPropertiesClause =  SET PROPERTIES "(" 
          "propertyNameList" ")" VALUES "(" "propertyValueList" ")"
     modifyDependencyDefinitionClause =  MODIFY DEPENDENCY_DEFINITION 
          "QUOTED_STRING" "setDependencyDefinitionPropertiesClause"
     deleteDependencyDefinitionClause =  DELETE DEPENDENCY_DEFINITION 
          "QUOTED_STRING"
     addDependencyDefinitionClause =  ADD DEPENDENCY_DEFINITION "QUOTED_STRING" 
          [ "setDependencyDefinitionPropertiesClause" ]
     propertyNameList =  "propertyNameClause" { "," "propertyNameClause" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setDependencyDefinitionPropertiesClause =  SET PROPERTIES "(" 
          "propertyNameList" ")" VALUES "(" "propertyValueList" ")"
     propertyNameClause =  ( "UNQUOTED_STRING" )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

parseRedefineAssociationCommand

Redefine an association between two classes..

setAssociationDefinitionPropertiesClause

Basic properties for re-defining ASSOCIATION_DEFINITION: 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: N/A
A descriptive text for this association.

Name: ROLE_1_MIN_CARDINALITY
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Minimum cardinality of role 1. Value can be positive integer.

Name: ROLE_1_MAX_CARDINALITY
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Maximum cardinality of role 1. Value can be positive integer or 'INFINITE'.

Name: ROLE_1_NAVIGABLE
Type: BOOLEAN 
Valid Values: true, false
Default: From user defined class side default is true. From OWB class side default is false.
Navigability of role 1. 

Name: ROLE_2_MIN_CARDINALITY
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Minimum cardinality of role 2. Value can be positive integer.

Name: ROLE_2_MAX_CARDINALITY
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Maximum cardinality of role 2. Value can be positive integer or 'INFINITE'.

Name: ROLE_2_NAVIGABLE
Type: BOOLEAN 
Valid Values: true, false
Default: From user defined class side default is true. From OWB class side default is false.
Navigability of role 2.

modifyDependencyDefinitionClause

Modifies the properties of the specified dependency for this association.

deleteDependencyDefinitionClause

Un-mark this association so that the dependency engine will ignore it when computing the lineage and impact dependencies of that type.

addDependencyDefinitionClause

Mark this association so that the dependency engine will consider it when computing the lineage and impact dependencies of the specified type. The only dependency type allowed here for now is 'DATAFLOW'.

propertyNameList

The list of property names.

propertyValueList

The list of property values being set.

setDependencyDefinitionPropertiesClause

Basic dependency-related properties for this association:

Name: SOURCE_ROLE_ID

Type: STRING(200)

Valid Values: ROLE_1, ROLE_2

Default: If one of the ends is a OWB class, then that is the default source. If both ends are user defined classes, then the association is default bidirectional.

Identifies the role (end) of the association which serves as the source for the dependency flow.

Name: BIDIRECTIONAL

Type: BOOLEAN

Valid Values: true, false

Default: If one of the ends is a OWB class, then default is false. If both ends are user defined classes, then default is true.

Specifies whether the association is bi-directional for the dependency flow.

propertyNameClause

Name of a property.

propertyValue

Value of a property.