OMBRETRIEVE OBJECT_TYPE

Purpose

Retrieve details of the Object Type.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

retrieveObjectTypeCommand =  OMBRETRIEVE OBJECT_TYPE "QUOTED_STRING" ( 
          "retrieveObjectTypeClause" | "retrieveAttributeClause" )
     retrieveObjectTypeClause =  GET ( "getPropertiesClause" | 
          "getReferenceIconSetClause" | "getAttributesClause" )
     retrieveAttributeClause =  OBJECT_TYPE_ATTRIBUTE "QUOTED_STRING" GET 
          "getPropertiesClause"
     getPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     getAttributesClause =  OBJECT_TYPE_ATTRIBUTES
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveObjectTypeCommand

Retrieves the details of the Object Type with the given name.

retrieveObjectTypeClause

Gets the properties or the Attribute names.

retrieveAttributeClause

Gets the properties of the Attribute with the given name.

getPropertiesClause

This clause retrieves all the properties.

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

getReferenceIconSetClause

Gets reference icon set.

getAttributesClause

Gets the names of all the Attributes of the Object Type with the given name.

propertyNameList

The list of properties.

OBJECT_TYPE Object

Table 20-1 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 20-2 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

OMBRETRIEVE OBJECT_TYPE

Purpose

Prerequisites

Syntax

Parameters

retrieveObjectTypeCommand

retrieveObjectTypeClause

retrieveAttributeClause

getPropertiesClause

getPropertiesClause

getReferenceIconSetClause

getAttributesClause

propertyNameList

OBJECT_TYPE Object

OBJECT_TYPE_ATTRIBUTE Object

See Also