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 ACTIVITY_TEMPLATE

Purpose

To alter activity template folder.

Prerequisites

Should be in the context of an Activity Template Folder.

Syntax

parseAlterTemplate =  "QUOTED_STRING" ( ( "renameClause" [ 
          "alterTemplatePropertiesOrIconSetClause" ] [ "modifyParametersClause" 
          ] ) | ( "alterTemplatePropertiesOrIconSetClause" [ 
          "modifyParametersClause" ] ) | "modifyParametersClause" )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterTemplatePropertiesOrIconSetClause =  ( ( SET "setPropertiesClause" ) |
           "setReferenceIconSetClause" | "unsetReferenceIconSetClause" )+
     modifyParametersClause =  ( "addParameterClause" | "modifyParameterClause" 
          | "deleteParameterClause" )+
     setPropertiesClause =  PROPERTIES "propertyKeyList" VALUES 
          "propertyValueList"
     setReferenceIconSetClause =  SET ( REFERENCE | REF ) ICONSET 
          "QUOTED_STRING"
     unsetReferenceIconSetClause =  UNSET ( REFERENCE | REF ) ICONSET
     addParameterClause =  ( ADD PARAMETER "QUOTED_STRING" ) [ SET 
          "setPropertiesClause" ]
     modifyParameterClause =  MODIFY PARAMETER "QUOTED_STRING" ( ( 
          "renameClause" [ SET "setPropertiesClause" ] ) | ( SET 
          "setPropertiesClause" ) )
     deleteParameterClause =  DELETE PARAMETER "QUOTED_STRING"
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     propertyValueList =  "(" "propertyValue" { "," "propertyValue" } ")"
     propertyKey =  "UNQUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

parseAlterTemplate

Alter the specified activity template.

renameClause

Rename the specified object.

alterTemplatePropertiesOrIconSetClause

Alter existing activity template properties and/or Icon Set.

modifyParametersClause

Modify the parameters of this activity template.

setPropertiesClause

This clause sets properties for the corresponding object.

getTemplatePropertiesClause

Basic properties for ACTIVITY_TEMPLATE:

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

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

getParameterPropertiesClause

Description of the Activity Template Core properties for Activity Parameter: 

Name: DATATYPE
Type: STRING
Valid Values: INTEGER, FLOAT, DATE, STRING, BOOLEAN
Default: STRING 
Sets the datatype of a Parameter 


Name: DIRECTION
Type: STRING
Valid Values: IN
Default: IN 
Sets the direction of a Parameter 


Name: DEFAULT_VALUE
Type: STRING
Valid Values: Examples '123', '123.456', 'Jan-08-2003', 'I am String', 'true'
Default: Empty string 
Sets the default value of a Parameter

setReferenceIconSetClause

Set icon set for the activity template.

unsetReferenceIconSetClause

Unset icon set for the activity template.

addParameterClause

Add a parameter to this activity template.

modifyParameterClause

Modify the definition of a parameter.

deleteParameterClause

Delete a parameter.

propertyKeyList

The list of property keys.

propertyValueList

A list of property values.

propertyKey

A property key for an object.

propertyValue

Value of a property.

PARAMETER Object

Table 1-1 PARAMETER Object

Property Type Choices Min Max Default Description

META_IMPORT_BYTES_PER_CHAR

NUMBER

none

none

none

1

 

META_IMPORT_CHARSET

STRING(45)

none

none

none

empty string

 

META_IMPORT_USE_CHAR_SEMANTICS

BOOLEAN

true, false

none

none

false