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

Part Number 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
 

OMBALTER ALTERNATIVE_SORT_ORDER

Purpose

Alters an alternative sort order.

Prerequisites

Should be in the context of a business definition module or use the full path.

Syntax

alterAlternativeSortOrderCommand =  ( OMBALTER ALTERNATIVE_SORT_ORDER 
          "QUOTED_STRING" ( ( "renameClause" [ SET 
          "setPropertiesClauseforLOVandD2D" ] [ SET "setReferenceIconSetClause" 
          ] [ UNSET "unsetReferenceIconSetClause" ] { 
          "alterAlternativeSortOrderClauses" } ) | ( SET 
          "setPropertiesClauseforLOVandD2D" [ SET "setReferenceIconSetClause" ] 
          [ UNSET "unsetReferenceIconSetClause" ] { 
          "alterAlternativeSortOrderClauses" } ) | ( SET 
          "setReferenceIconSetClause" [ UNSET "unsetReferenceIconSetClause" ] { 
          "alterAlternativeSortOrderClauses" } ) | ( UNSET 
          "unsetReferenceIconSetClause" { "alterAlternativeSortOrderClauses" } )
           | ( "alterAlternativeSortOrderClauses" { 
          "alterAlternativeSortOrderClauses" } ) ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClauseforLOVandD2D =  PROPERTIES "(" 
          "propertyNameListforLOVandD2D" ")" VALUES "(" "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     alterAlternativeSortOrderClauses =  SET ( REF | REFERENCE ) 
          "addAlternativeSortOrderClauseforAlter" | UNSET ( REF | REFERENCE ) 
          "deleteAlternativeSortOrderClauses" | 
          "addAlternativeSortOrderReferenceClause"
     propertyNameListforLOVandD2D =  ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) { 
          "," ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     addAlternativeSortOrderClauseforAlter =  ( DEFINING ITEM "QUOTED_STRING" OF
           ITEM_FOLDER "QUOTED_STRING" ) | ( ORDERED ITEM "QUOTED_STRING" OF 
          ITEM_FOLDER "QUOTED_STRING" )
     deleteAlternativeSortOrderClauses =  ( DEFINING ITEM ) | ( ORDERED ITEM ) |
           ( ITEM "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING" )
     addAlternativeSortOrderReferenceClause =  SET ( REF | REFERENCE ) ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterAlternativeSortOrderCommand

This clause alters an alternative sort order.

QUOTED_STRING

name of the alternative sort order.

renameClause

Renames an alternative sort order with a different name.

setPropertiesClauseforLOVandD2D

This clause sets the properties of the object.

getPropertiesClauseforLOVandD2D

Basic properties for ALTERNATIVE_SORT_ORDER: 

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

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

Name: DRILL_TO_DETAIL
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether the alternative sort order enables drilling between the item folders containing the items that use the alternative sort order 

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.

alterAlternativeSortOrderClauses

This clause modifies an alternative sort order.

propertyNameListforLOVandD2D

This is the list of property names.

propertyValueList

This is the list of property values.

addAlternativeSortOrderClauseforAlter

This clause sets the defining item or ordering item for the alternative sort order.

DEFINING

This sets the defining item for the alternative sort order.

ORDERED

This sets the ordered item for the alternative sort order.

deleteAlternativeSortOrderClauses

This deletes specific item references from an alternative sort order.

DEFINING

This deletes the defining item from an alternative sort order.

ITEM

This deletes a reference to an item from an alternative sort order.

ORDERED

This deletes the ordered item from an alternative sort order.

addAlternativeSortOrderReferenceClause

This adds a reference to an item to an alternative sort order.

propertyValue

This is a property value.

ALTERNATIVE_SORT_ORDER Object

Table 1-3 ALTERNATIVE_SORT_ORDER 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