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

OMBALTER BUSINESS_DEFINITION_MODULE

Purpose

Alter a business definition module by renaming it, and/or reset its properties.

Prerequisites

Should be in the context of project.

Syntax

alterEULModuleCommand =  OMBALTER ( BUSINESS_DEFINITION_MODULE 
          "QUOTED_STRING" ( "renameClause" [ 
          "alterPropertiesOrReferenceClauseForDataOnlyModule" ] | 
          "alterPropertiesOrReferenceClauseForDataOnlyModule" | 
          "addOrRemoveOrModifyModuleReferenceLocationClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrReferenceClauseForDataOnlyModule =  ( ( SET ( ( 
          "setPropertiesClause" [ ( SET "setReferenceClauseForDataOnlyModule" [ 
          UNSET "unsetReferenceClauseForDataOnlyModule" ] ) | ( UNSET 
          "unsetReferenceClauseForDataOnlyModule" [ SET 
          "setReferenceClauseForDataOnlyModule" ] ) ] ) | ( 
          "setReferenceClauseForDataOnlyModule" [ UNSET 
          "unsetReferenceClauseForDataOnlyModule" ] ) ) ) | ( UNSET 
          "unsetReferenceClauseForDataOnlyModule" [ SET 
          "setReferenceClauseForDataOnlyModule" ] ) ) [ 
          "addOrRemoveOrModifyModuleReferenceLocationClause" ]
     addOrRemoveOrModifyModuleReferenceLocationClause =  ( 
          "addReferenceLocationClause" | "removeReferenceLocationClause" | 
          "modifyReferenceLocationClause" ) { "addReferenceLocationClause" | 
          "removeReferenceLocationClause" | "modifyReferenceLocationClause" }
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceClauseForDataOnlyModule =  ( "setReferenceLocationClause" [ SET
           "setReferenceIconSetClause" ] | "setReferenceIconSetClause" )
     unsetReferenceClauseForDataOnlyModule =  ( "unsetReferenceLocationClause" [
           UNSET "unsetReferenceIconSetClause" ] | "unsetReferenceIconSetClause"
           )
     addReferenceLocationClause =  ADD ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING" [ SET AS DEFAULT ]
     removeReferenceLocationClause =  REMOVE ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     modifyReferenceLocationClause =  MODIFY ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING" SET AS DEFAULT
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setReferenceLocationClause =  ( REFERENCE | REF ) LOCATION "QUOTED_STRING"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceLocationClause =  ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterEULModuleCommand

This command modifies an existing business definition module.

QUOTED_STRING

Name of the existing business definition module in single quotes.

renameClause

Rename a business definition module.

alterPropertiesOrReferenceClauseForDataOnlyModule

Alter existing business definition module's properties and/or locations and/or icon sets.

addOrRemoveOrModifyModuleReferenceLocationClause

Add/remove/modify data location for the business definition module.

setPropertiesClause

Associate a set of properties with the existing business definition module.

getPropertiesClause

Basic properties for BUSINESS_DEFINITION_MODULE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of a business definition module 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of a business definition module

setReferenceClauseForDataOnlyModule

Set location and/or icon set for the new business definition module.

unsetReferenceClauseForDataOnlyModule

Unset location and/or icon set for the business definition module.

addReferenceLocationClause

Add a data location to the new business definition module.

removeReferenceLocationClause

Remove a data location from the business definition module.

modifyReferenceLocationClause

Modify a data location of the business definition module.

propertyNameList

Comma-separated list of property names. Property names are not in quotes.

propertyValueList

Comma-separated list of property values.

setReferenceLocationClause

Set a data location for the existing business definition module as the new configuration default.

setReferenceIconSetClause

Set icon set for the new business definition module.

unsetReferenceLocationClause

Unset a data location for the existing business definition module.

unsetReferenceIconSetClause

Unset icon set for the business definition module.

propertyValue

Value for a specified property.

BUSINESS_DEFINITION_MODULE Object

Table 1-5 BUSINESS_DEFINITION_MODULE Object

Property Type Choices Min Max Default Description

DB_LOCATION

STRING

none

none

none

empty string

Location for Business Intelligence Module

DEPLOYABLE

BOOLEAN

true, false

none

none

true

Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true

MLS_DEPLOYMENT_LANGUAGE

STRING

none

none

none

MLS_BASE_LANGUAGE

MLS Language to be used for deployment

OBJECT_MATCHING

STRING

BY_IDENTIFIER, BY_NAME

none

none

BY_IDENTIFIER

Whether import should match up objects by identifier or by name