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

OMBCREATE DATA_RULE

Purpose

Create a DataRule rule in an dataRule rule Module.

Prerequisites

1. The current context of scripting must be an DataRule Rule Module.

2. No concurrent user should be locking the DataRule Rule Module or any of its ancestors exclusively at the moment the rule is being created.

3. The rule name must not conflict with existing rule names.

Syntax

createDataRuleCommand =  OMBCREATE ( DATA_RULE "QUOTED_STRING" [ SET ( 
          "setInitialPropertiesClause" [ SET "setReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) ] [ ADD "addDomainValueClause" ] )
     setInitialPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES 
          "(" "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addDomainValueClause =  ( DOMAIN_VALUE "QUOTED_STRING" )
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createDataRuleCommand

Create a data rule.

QUOTED_STRING

Data rule name.

setInitialPropertiesClause

Set properties associated with the created data rule. The property RULE_TYPE must be set.

setReferenceIconSetClause

Set icon set for the data rule.

addDomainValueClause

Add a domain value.

QUOTED_STRING

Domain value.

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

propertyValue

Value of a property.