Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

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 COLLECTION

Purpose

This is an arbitrary grouping mechanism in OWB. Any first class object can be added to the collection.

Prerequisites

Should be in the context of a project, before creating a collection.

Syntax

createCollectionCommand =  OMBCREATE ( COLLECTION "QUOTED_STRING" [ SET 
          "setPropertiesClause" [ SET "setReferenceIconSetClause" ] | SET 
          "setReferenceIconSetClause" ] ( { "addReferenceClause" } ) )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addReferenceClause =  ADD REFERENCE TO "componentRefClause"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     componentRefClause =  ( "UNQUOTED_STRING" "QUOTED_STRING" )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createCollectionCommand

Create a collection of objects.

setPropertiesClause

Set values for a number of properties when creating the collection.

propertiesClause

Basic properties for COLLECTION: 

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

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

setReferenceIconSetClause

Set icon set for the collection.

addReferenceClause

Add a reference to the collection.

propertyNameList

Comma separated list of property names to retrieve values. Property names are unquoted.

propertyValueList

Comma separated list of property values.

componentRefClause

Specify the type of the object to reference.

propertyValue

Value of property.