OMBALTER OBJECT_TYPE

Purpose

Alter the Object Type by resetting its properties or adding/removing its attributes.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

alterObjectTypeCommand =  OMBALTER ( OBJECT_TYPE "QUOTED_STRING" ( 
          "renameClause" [ "alterPropertiesOrIconSetClause" ] [ 
          "alterAttributesClause" ] | "alterPropertiesOrIconSetClause" [ 
          "alterAttributesClause" ] | "alterAttributesClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( "setPropertiesClause" [ SET ( REF |
           REFERENCE ) "setReferenceIconSetClause" | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause" ] | ( REF | REFERENCE ) 
          "setReferenceIconSetClause" ) | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause"
     alterAttributesClause =  ( "addAttributeClause" | "deleteAttributeClause" |
           "modifyAttributeClause" )+
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ICONSET
     addAttributeClause =  ADD OBJECT_TYPE_ATTRIBUTE "QUOTED_STRING" [ AT 
          POSITION "INTEGER_LITERAL" ] [ SET "setPropertiesClause" ]
     deleteAttributeClause =  DELETE OBJECT_TYPE_ATTRIBUTE "QUOTED_STRING"
     modifyAttributeClause =  MODIFY OBJECT_TYPE_ATTRIBUTE "QUOTED_STRING" ( 
          "renameClause" [ "moveToAttributeClause" ] [ SET "setPropertiesClause"
           ] | "moveToAttributeClause" [ SET "setPropertiesClause" ] | SET 
          "setPropertiesClause" )
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     moveToAttributeClause =  MOVE TO POSITION "INTEGER_LITERAL"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterObjectTypeCommand

Alters an Object Type of the given name by either renaming it, or by setting it's properties or by modifying one or more of its Attributes or a combination of these.

renameClause

renames a table with a different name.

alterPropertiesOrIconSetClause

Alters Object Type properties or icon set.

alterAttributesClause

Adds, deletes or modifies one or more Attributes of this Object Type.

setPropertiesClause

Sets properties (core, logical, physical, user-defined) for Object Type or its Attributes.

getPropertiesClause

Basic properties for OBJECT_TYPE: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the Object Type

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the Object Type

Basic properties for OBJECT_TYPE_ATTRIBUTE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the Attribute

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the Attribute 

Name: DATATYPE
Type: STRING(20)
Valid Values: BINARY_DOUBLE, BINARY_FLOAT, BLOB, CHAR, CLOB, DATE, FLOAT, INTEGER, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, NCHAR, NCLOB, NUMBER, NVARCHAR2, RAW, SYS.ANYDATA, SYS.LCR$_ROW_RECORD, XMLFORMAT, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARHCAR, VARCHAR2, XMLTYPE
Default: Empty string
Datatype of the Attribute

setReferenceIconSetClause

Sets reference icon set.

unsetReferenceIconSetClause

Unsets reference icon set.

addAttributeClause

Adds an Attribute with the given name and properties.

deleteAttributeClause

Deletes an Attribute with the given name.

modifyAttributeClause

Modifies an Attribute with the given name by either renaming it or changing its properties or both.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

moveToAttributeClause

Modifies an attributes position from current position to given position.

propertyValue

This clause adds the property values.

OBJECT_TYPE Object

Table 3-59 OBJECT_TYPE Object

Property	Type	Choices	Min	Max	Default	Description
DEPLOYABLE	BOOLEAN	true, false	none	none	true	Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
GENERATION_COMMENTS	STRING	none	none	none	empty string	Enter additional comments for the generated code.

OBJECT_TYPE_ATTRIBUTE Object

Table 3-60 OBJECT_TYPE_ATTRIBUTE Object

Property	Type	Choices	Min	Max	Default
META_IMPORT_BYTES_PER_CHAR	NUMBER	none	none	none	1
META_IMPORT_CHARSET	STRING(45)	none	none	none	empty string
META_IMPORT_USE_CHAR_SEMANTICS	BOOLEAN	true, false	none	none	false