OMBCREATE LIST_OF_VALUES

Purpose

Creates a List of Values.

Prerequisites

Should be in the context of a Business Definition Module.

Syntax

createListOfValuesCommand =  OMBCREATE LIST_OF_VALUES "QUOTED_STRING" [ SET
           "setPropertiesClauseforLOVandD2D" ] [ SET "setReferenceIconSetClause"
           ] [ "addListOfValuesClause" ] { "addListOfValuesReferenceClause" }
     setPropertiesClauseforLOVandD2D =  PROPERTIES "(" 
          "propertyNameListforLOVandD2D" ")" VALUES "(" "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addListOfValuesClause =  SET ( REF | REFERENCE ) DEFINING ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     addListOfValuesReferenceClause =  SET ( REF | REFERENCE ) ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     propertyNameListforLOVandD2D =  ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) { 
          "," ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createListOfValuesCommand

This command creates a list of values.

QUOTED_STRING

Specify the name of the list of values to be created.

setPropertiesClauseforLOVandD2D

Used to set properties (core, logical, physical, user-defined) for a list of values. Valid properties are shown below:

getPropertiesClauseforLOVandD2D

Basic properties for LIST_OF_VALUES: 

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

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

Name: DRILL_TO_DETAIL
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether the list of values enables drilling between the item folders containing the items that use the list of values 

Name: RETRIEVE_VALUES_GROUP_SIZE
Type: Number
Valid Values: Any valid character string in supported character set.
Default: '100'
The number of rows to be fetched from the database at a time 

Name: CACHE_VALUES
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the list of values should be cached in memory 

Name: REQUIRE_SEARCH
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether search criteria should be requested 

Name: SHOW_IN_NAVIGATOR
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the values should be shown in the item navigator 

Name: SORTED_DISTINCT
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the values should be displayed sorted with duplicates hidden

setReferenceIconSetClause

Set specified Icon Set.

addListOfValuesClause

This clause modifies a list of values.

addListOfValuesReferenceClause

This adds a reference to an item to a list of values.

propertyNameListforLOVandD2D

This is the list of property names.

propertyValueList

This is the list of property values.

propertyValue

This is a property value.

LIST_OF_VALUES Object

Table 8-2 LIST_OF_VALUES 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 objects marked as Deployable = true