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
Mobi · ePub

OMBALTER CATALOG_FOLDER

Purpose

Alters a catalog folder.

Prerequisites

Should be in the context of an OBIEE Business Definition Module or use the full path.

Syntax

alterCatalogFolderCommand =  ( OMBALTER CATALOG_FOLDER "QUOTED_STRING" ( ( 
          "renameClause" [ SET "setPropertiesClause" ] [ SET 
          "setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ] 
          { "alterCatalogFolderClauses" } ) | ( SET "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" ] [ UNSET "unsetReferenceIconSetClause" ] 
          { "alterCatalogFolderClauses" } ) | ( SET "setReferenceIconSetClause" 
          [ UNSET "unsetReferenceIconSetClause" ] { "alterCatalogFolderClauses" 
          } ) | ( UNSET "unsetReferenceIconSetClause" { 
          "alterCatalogFolderClauses" } ) | ( "alterCatalogFolderClauses" { 
          "alterCatalogFolderClauses" } ) ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     alterCatalogFolderClauses =  ( SET ( REF | REFERENCE ) LOGICAL_TABLES "(" 
          "setLogicalTableNameList" ")" | SET ( REF | REFERENCE ) DRILL_PATHS 
          "(" "setDrillPathNameList" ")" | UNSET ( REF | REFERENCE ) 
          LOGICAL_TABLES "(" "unsetLogicalTableNameList" ")" | UNSET ( REF | 
          REFERENCE ) DRILL_PATHS "(" "unsetDrillPathNameList" ")" )
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setLogicalTableNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     setDrillPathNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     unsetLogicalTableNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     unsetDrillPathNameList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterCatalogFolderCommand

This clause alters a catalog folder.

QUOTED_STRING

name of the catalog folder.

renameClause

Renames a catalog folder with a different name.

setPropertiesClause

This clause sets the properties of the object.

getPropertiesClause

Basic properties for CATALOG_FOLDER: 

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

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

setReferenceIconSetClause

Set specified Icon Set.

unsetReferenceIconSetClause

Unset specified Icon Set.

alterCatalogFolderClauses

This clause adds or deletes catalog folder shortcuts.

propertyNameList

This is the list of property names.

propertyValueList

This is the list of property values.

setLogicalTableNameList

Used to set logical table references for this catalog folder.

setDrillPathNameList

Used to set logical table references for this catalog folder.

unsetLogicalTableNameList

Used to remove logical table references for this catalog folder.

unsetDrillPathNameList

Used to remove logical table references for this catalog folder.

propertyValue

This is a property value.

CATALOG_FOLDER Object

Table 1-8 CATALOG_FOLDER 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