Syntax
alterListOfValuesCommand = ( OMBALTER LIST_OF_VALUES "QUOTED_STRING" ( (
"renameClause" [ SET "setPropertiesClauseforLOVandD2D" ] [ SET
"setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ]
{ "alterListOfValuesClauses" } ) | ( SET
"setPropertiesClauseforLOVandD2D" [ SET "setReferenceIconSetClause" ]
[ UNSET "unsetReferenceIconSetClause" ] { "alterListOfValuesClauses" }
) | ( SET "setReferenceIconSetClause" [ UNSET
"unsetReferenceIconSetClause" ] { "alterListOfValuesClauses" } ) | (
UNSET "unsetReferenceIconSetClause" { "alterListOfValuesClauses" } ) |
( "alterListOfValuesClauses" { "alterListOfValuesClauses" } ) ) )
renameClause = RENAME TO "QUOTED_STRING"
setPropertiesClauseforLOVandD2D = PROPERTIES "("
"propertyNameListforLOVandD2D" ")" VALUES "(" "propertyValueList" ")"
setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
unsetReferenceIconSetClause = ( REFERENCE | REF ) ICONSET
alterListOfValuesClauses = SET ( REF | REFERENCE ) DEFINING ITEM
"QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING" | UNSET ( REF |
REFERENCE ) "deleteListOfValuesClauses" |
"addListOfValuesReferenceClause"
propertyNameListforLOVandD2D = ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) {
"," ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) }
propertyValueList = "propertyValue" { "," "propertyValue" }
deleteListOfValuesClauses = ( DEFINING ITEM ) | ( ITEM "QUOTED_STRING" OF
ITEM_FOLDER "QUOTED_STRING" )
addListOfValuesReferenceClause = SET ( REF | REFERENCE ) ITEM
"QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" |
"FLOATING_POINT_LITERAL" )
Parameters
alterListOfValuesCommand
This clause alters a list of values.
QUOTED_STRING
name of the list of values.
renameClause
Renames a list of values with a different name.
setPropertiesClauseforLOVandD2D
This clause sets the properties of the object.
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.
unsetReferenceIconSetClause
Unset specified Icon Set.
alterListOfValuesClauses
This clause modifies a list of values.
DEFINING
This sets the defining item for the list of values.
propertyNameListforLOVandD2D
This is the list of property names.
propertyValueList
This is the list of property values.
deleteListOfValuesClauses
This deletes a reference to an item from a list of values.
addListOfValuesReferenceClause
This adds a reference to an item to a list of values.
propertyValue
This is a property value.
