../E14406-01.epub /> ../E14406-01.mobi />

OMBCREATE OBJECT_TYPE

Purpose

To create an Object Type.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

createObjectTypeCommand =  OMBCREATE ( OBJECT_TYPE "QUOTED_STRING" [ SET ( 
          "setPropertiesClause" [ SET ( REF | REFERENCE ) 
          "setReferenceIconSetClause" ] | ( REF | REFERENCE ) 
          "setReferenceIconSetClause" ) ] [ "addObjectAttributesClause" ] )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ICONSET "QUOTED_STRING"
     addObjectAttributesClause =  "addAttributeClause"+
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     addAttributeClause =  ADD OBJECT_TYPE_ATTRIBUTE "QUOTED_STRING" [ AT 
          POSITION "INTEGER_LITERAL" ] [ SET "setPropertiesClause" ]
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createObjectTypeCommand

Creates an Object Type with the given name.

setPropertiesClause

Sets properties (core, logical, physical, user-defined) for Object Type or its Attributes. Valid properties are shown below:

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.

addObjectAttributesClause

Adds one or more Attributes in this Object Type.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

addAttributeClause

Adds an Attribute with the given name and properties.

propertyValue

This clause adds the property values.

OBJECT_TYPE Object

Table 8-60 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 8-61 OBJECT_TYPE_ATTRIBUTE Object

Property Type Choices Min Max Default Description

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