OMBCREATE ACTIVITY_TEMPLATE

Purpose

To create an activity template.

Valid Activity Template types are:

ASSIGN

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