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
 

OMBCREATE ACTIVITY_TEMPLATE

Purpose

To create an activity template.

Valid Activity Template types are:

ASSIGN

EMAIL

FILE_EXISTS

FTP

MANUAL

NOTIFICATION

SET_STATUS

SQLPLUS

USER_DEFINED

WAIT

Prerequisites

Should be in the context of an Activity Template Folder.

Syntax

createActivityTemplate =  ( OMBCREATE ACTIVITY_TEMPLATE "QUOTED_STRING" [ (
           OF ACTIVITY_TYPE "UNQUOTED_STRING" ) ] { ( SET "setPropertiesClause" 
          ) | "setReferenceIconSetClause" } { "addParameterClause" } )
     setPropertiesClause =  PROPERTIES "propertyKeyList" VALUES 
          "propertyValueList"
     setReferenceIconSetClause =  SET ( REFERENCE | REF ) ICONSET 
          "QUOTED_STRING"
     addParameterClause =  ( ADD PARAMETER "QUOTED_STRING" ) [ SET 
          "setPropertiesClause" ]
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     propertyValueList =  "(" "propertyValue" { "," "propertyValue" } ")"
     propertyKey =  "UNQUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createActivityTemplate

Create an 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.

addParameterClause

Add a variable to the activity template.

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 5-8 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