OMBALTER DATA_RULE

Purpose

= Alter the content of a data rule.

Prerequisites

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

2. No concurrent user should be modifying the data rule

Syntax

alterDataRuleCommand =  OMBALTER ( DATA_RULE "QUOTED_STRING" ( 
          "ruleRenameClause" [ "alterPropertiesOrIconSetClause" ] | 
          "alterPropertiesOrIconSetClause" | ( ADD "addDomainValueClause" )+ | (
           REMOVE "removeDomainValueClause" )+ | "alterGroupClause"+ | 
          "alterDomainValueClause"+ ) )
     ruleRenameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) | UNSET "unsetReferenceIconSetClause"
     addDomainValueClause =  ( DOMAIN_VALUE "QUOTED_STRING" )
     removeDomainValueClause =  DOMAIN_VALUE "QUOTED_STRING"
     alterGroupClause =  GROUP "QUOTED_STRING" ( "setGroupPropertiesClause" | 
          "addAttributeClause"+ | "removeAttributeClause"+ | 
          "alterAttributeClause"+ )
     alterDomainValueClause =  DOMAIN_VALUE "QUOTED_STRING" 
          "domainValueRenameClause"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     setGroupPropertiesClause =  SET PROPERTIES "(" "propertyNameList" ")" 
          VALUES "(" "propertyValueList" ")"
     addAttributeClause =  ADD ATTRIBUTE ( "QUOTED_STRING" [ SET 
          "setPropertiesClause" ] )
     removeAttributeClause =  REMOVE ATTRIBUTE "QUOTED_STRING"
     alterAttributeClause =  ATTRIBUTE ( "QUOTED_STRING" SET 
          "setPropertiesClause" )
     domainValueRenameClause =  RENAME TO "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterDataRuleCommand

Alter a data rule.

QUOTED_STRING

Data rule name.

ruleRenameClause

Rename a data rule.

QUOTED_STRING

New name.

alterPropertiesOrIconSetClause

Alter properties or the icon set.

addDomainValueClause

Add a domain value.

QUOTED_STRING

Domain value.

removeDomainValueClause

Remove a domain value.

QUOTED_STRING

Domain value.

alterGroupClause

Alter a data rule group.

QUOTED_STRING

Data rule group name.

alterDomainValueClause

Alter a domain value.

QUOTED_STRING

Domain value name.

setPropertiesClause

Set the properties of the data rule.

getPropertiesClause

Properties of Data Rule are:

Basic properties for DATA_RULE:

Name: DATA_NAME

Type: STRING(200)

Valid Values: Any valid character string in supported character set.

Default: Empty string

Business name of the Data Rule

Name: DESCRIPTION

Type: STRING(4000)

Valid Values: Any valid character string in supported character set.

Default: Empty string

Description of the Data Rule

Name: RULE_TYPE

Type: STRING

Valid Values: ATTR_VALUE_RULE

DOMAIN_NO_NULL_RULE

DOMAIN_LIST_RULE

DOMAIN_PATTERN_LIST_RULE

DOMAIN_RANGE_RULE

DOMAIN_FORMAT_TELEPHONE_RULE

DOMAIN_FORMAT_IP_RULE

DOMAIN_FORMAT_SSN_RULE

DOMAIN_FORMAT_DATE_RULE

DOMAIN_FORMAT_NUMBER_RULE

DOMAIN_FORMAT_URL_RULE

DOMAIN_FORMAT_EMAIL_RULE

FUNCTIONAL_DEP_RULE

SET_RULE

IDENTITY_RULE

REFERENCE_RULE

Default: ATTR_VALUE_RULE

Data Rule type

Name: ATTR_VALUE_CLAUSE

Type: STRING(4000)

Valid Values: Any valid character string in supported character set.

Default: Empty string

Expression used in the ATTR_VALUE_RULE

Name: LOCAL_MIN_COUNT

Type: STRING

Valid Values: Any valid character string in supported character set.

Default: 1

Used in the REFERENCE_RULE to set the max and min counts for the local and remote side of a relation. For a 1-n relationship, set the local max count to 1 and remote min count to 0 or 1. For an n-1 relationship, set the local max count to n and remote max count to 1.

Name: LOCAL_MAX_COUNT

Type: STRING

Valid Values: Any valid character string in supported character set.

Default: n

Used in the REFERENCE_RULE to set the max and min counts for the local and remote side of a relation. For a 1-n relationship, set the local max count to 1 and remote min count to 0 or 1. For an n-1 relationship, set the local max count to n and remote max count to 1.

Name: REMOTE_MIN_COUNT

Type: STRING

Valid Values: Any valid character string in supported character set.

Default: 0

Used in the REFERENCE_RULE to set the max and min counts for the local and remote side of a relation. For a 1-n relationship, set the local max count to 1 and remote min count to 0 or 1. For an n-1 relationship, set the local max count to n and remote max count to 1.

Name: REMOTE_MAX_COUNT

Type: STRING

Valid Values: Any valid character string in supported character set.

Default: 'n'

Used in the REFERENCE_RULE to set the max and min counts for the local and remote side of a relation. For a 1-n relationship, set the local max count to 1 and remote min count to 0 or 1. For an n-1 relationship, set the local max count to n and remote max count to 1.

Name: MAX_VALUE

Type: STRING

Valid Values: Any valid character string in supported character set.

Default: Empty string

Used in the DOMAIN_RANGE_RULE. Leave the min or max value blank is not used. For instance, the rule: attr >= 10 would have a max value and no min_value.

Name: MIN_VALUE

Type: STRING

Valid Values: Any valid character string in supported character set.

Default: Empty string

Used in the DOMAIN_RANGE_RULE. Leave the min or max value blank is not used. For instance, the rule: attr >= 10 would have a max value and no min_value.

Name: IGNORE_NULLS

Type: BOOLEAN

Valid Values: Any valid character string in supported character set.

Default: false

Used in identity and reference rules. If set, then records containing null values will not evaluated.

Properties of Data Rule Attribute are:

Name: DATATYPE

Type: STRING

Valid Values: DATE, NUMBER, VARCHAR2

Default: NUMBER

Set the data type for Parameter. Should be set for attributes on ATTR_VALUE and DOMAIN_RANGE rules

setReferenceIconSetClause

Set icon set for the data rule.

unsetReferenceIconSetClause

Unset icon set for the data rule.

setGroupPropertiesClause

Set the properties in a group.

addAttributeClause

Add an attribute to a group.

removeAttributeClause

Remove an attribute from a group.

alterAttributeClause

ALter an attribute.

domainValueRenameClause

Rename a 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.

DATA_RULE Object

Table 2-6 DATA_RULE Object

Property	Type	Choices	Min	Max	Default	Description
ATTR_VALUE_CLAUSE	STRING	none	none	none	empty string	Description not available.
DIAGRAM_LAYOUT	STRING	none	none	none	empty string
DUAL_ADDRESS_ASSIGNMENT	STRING	NA_DUALADDR_CLOSESTTOLASTLINE, NA_DUALADDR_POBOX, NA_DUALADDR_STREET	none	none	NA_DUALADDR_STREET	Description not available.
FUNCTIONAL_DEP_THRESHOLD	NUMBER	none	none	none	0	Description not available.
IGNORE_NULLS	BOOLEAN	true, false	none	none	false	Description not available.
LOCAL_MAX_COUNT	STRING	none	none	none	n	Description not available.
LOCAL_MIN_COUNT	STRING	none	none	none	1	Description not available.
MAX_VALUE	STRING	none	none	none	empty string	Description not available.
MIN_VALUE	STRING	none	none	none	empty string	Description not available.
NAMEADDR_PASS_CONDITION	STRING	PASS_PARSED, PASS_POSTALMATCHED_AVAIL	none	none	PASS_PARSED	Description not available.
PARSING_TYPE	STRING	NA_ADDRESSONLY, NA_NAMEANDADDRESS, NA_NAMEONLY	none	none	NA_NAMEANDADDRESS	Description not available.
PRIMARY_COUNTRY	STRING	NA_AND, NA_ARE, NA_ARG, NA_AUS, NA_AUT, NA_BEL, NA_BGD, NA_BGR, NA_BHS, NA_BLZ, NA_BMU, NA_BRA, NA_BRB, NA_BRN, NA_CAN, NA_CHE, NA_CHL, NA_CHN, NA_COL, NA_CZE, NA_DEU, NA_DNK, NA_EGY, NA_ESP, NA_EST, NA_FIN, NA_FRA, NA_GBR, NA_GRC, NA_GUM, NA_HKG, NA_HUN, NA_ICL, NA_IND, NA_IRL, NA_IRN, NA_IRQ, NA_ISR, NA_ITA, NA_JAM, NA_JOR, NA_JPN, NA_KHM, NA_KOR, NA_LIE, NA_LTU, NA_LUX, NA_LVA, NA_MEX, NA_MYS, NA_NLD, NA_NOR, NA_NZL, NA_PAK, NA_PER, NA_PHL, NA_POL, NA_PRT, NA_ROM, NA_RUS, NA_SGP, NA_SVN, NA_SWE, NA_THA, NA_UKR, NA_USA, NA_VEN, NA_YUG, NA_ZAF	none	none	NA_USA	Description not available.
REMOTE_MAX_COUNT	STRING	none	none	none	n	Description not available.
REMOTE_MIN_COUNT	STRING	none	none	none	empty string	Description not available.
RULE_TYPE	STRING	, ATTR_VALUE_RULE, DOMAIN_FORMAT_DATE_RULE, DOMAIN_FORMAT_EMAIL_RULE, DOMAIN_FORMAT_IP_RULE, DOMAIN_FORMAT_NUMBER_RULE, DOMAIN_FORMAT_SSN_RULE, DOMAIN_FORMAT_TELEPHONE_RULE, DOMAIN_FORMAT_URL_RULE, DOMAIN_LIST_RULE, DOMAIN_NO_NULL_RULE, DOMAIN_PATTERN_LIST_RULE, DOMAIN_RANGE_RULE, FUNCTIONAL_DEP_RULE, IDENTITY_RULE, NAMEADDRESS_RULE, REFERENCE_RULE, SET_RULE	none	none	empty string	Description not available.

See Also

OMBALTER

OMBCREATE DATA_RULE

OMBDROP DATA_RULE