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

OMBDEFINE ASSOCIATION_DEFINITION

Purpose

To define an association between two classes (types).

Prerequisites

Association definition to be defined should not already exist. User must have CREATE_EXTENSIONMODEL system privilege and has to be connected in single user mode to run this command.

Syntax

parseDefineAssociationCommand =  OMBDEFINE ASSOCIATION_DEFINITION 
          "QUOTED_STRING" [ ( ON | OF ) "modelClause" ] 
          "setAssociationDefinitionPropertiesClause" { 
          "addDependencyDefinitionClause" }
     modelClause =  ( MODEL "QUOTED_STRING" | PLATFORM "QUOTED_STRING" | 
          CONFIGURATION_TEMPLATE "QUOTED_STRING" ( ON | OF ) PLATFORM 
          "QUOTED_STRING" )
     setAssociationDefinitionPropertiesClause =  SET PROPERTIES "(" 
          "propertyNameList" ")" VALUES "(" "propertyValueList" ")"
     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

parseDefineAssociationCommand

Define an association between two classes..

getAssociationPropertiesClause

Basic properties for 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: CLASS_1 
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Class on one side of the association.

NAME: CLASS_2 
Type: STRING(200) 
Value Values: N/A
Default: N/A
Class on the other side of the association.

Name: ROLE_1
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Role on one side of the association. 

Name: ROLE_2
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: N/A
Role on the other side of the 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.

addDependencyDefinitionClause

Mark this association so that the dependency engine will consider it when computing the lineage and impact dependencies. 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.