OMBCREATE PROCESS_FLOW

createProcessFlowCommand

Create a new process flow using quoted name.

setPropertiesClause

Used to set properties (core, user-defined) for process flow. Note: For MAPPING, TRANSFORMATION and SUBPROCESS

activities the setPropertiesAndReferencesMapClauses,

setPropertiesAndReferencesFunctionClauses and

setPropertiesAndReferencesSubProcessClauses respectively,

are mandatory.

For MAPPING or TRANSFORMATION activities and the REFERENCE property has to be set to a

valid MAP or TRANSFORMATION within the current project.

For SUBPROCESS activities the REFERENCE property has to be set

to a SUBPROCESS within the same PROCESS_FLOW_PACKAGE.

Valid properties are shown below:

setPropertiesClause

Base properties for PROCESS_FLOW:
Basic properties for Process Flow, Activity, Transition and Parameter: 

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

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

Description of the Process Flow Core properties for Transition : 

Name: TRANSITION_CONDITION
Type: STRING
Valid Values: '', SUCCESS, ERROR, WARNING
Default: Empty string i.e. Unconditional
Sets the Transition Condition of a Transition 

Name: SIMPLE_CONDITION
Type: STRING
Valid Values: '', SUCCESS, ERROR, WARNING
Default: Empty string i.e. Unconditional
Sets the Simple Condition of a Transition 

Name: COMPLEX_CONDITION
Type: STRING
Sets the Complex Condition of a Transition 

Description of the Process Flow Core properties for Activity Parameter : 

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


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


Name: ISLITERALVALUE
Type: STRING
Valid Values: TRUE FALSE
Default: TRUE 
Whether the value stored is a literal value or an interpreted value, valid for PARAMETERS and VARIABLES.


Name: VALUE
Type: STRING
Valid Values: Examples '123', '123.456', 'Jan-08-2003', 'I am String', 'true'
Default: Empty string 
For Mapping activities representing PLSQL maps, the allowed value for the parameters:
OPERATING_MODE:'SET_BASED' 'ROW_BASED' 'ROW_BASED_TARGET_ONLY' 'SET_BASED_FAIL_OVER_TO_ROW_BASED' 'SET_BASED_FAIL_OVER_TO_ROW_BASED_TARGET_ONLY'
AUDIT_LEVEL:'NONE' 'STATISTICS' 'ERROR_DETAILS' 'COMPLETE' 
Sets the value of a Activity Parameter


Name: BINDING
Type: STRING
Valid Values: Examples 'PARAM_1', 'PARAM_2' 
Default: Empty string 
Represents the parameter on the process flow that this parameter is bound to. 
When setting users can specify the name of any PROCESS PARAMETER of same datatype. 
This feature allows for parameterizing the process flow. If the parameter is bound 
the VALUE property is ignored when generating the process flow.
To unbind a parameter, use an empty quoted string ie. '', and the parameter will be unbound.


Name: BOUND_NAME
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: Empty string
The name of the object which a process flow activity represents, for example, a mapping.


Name: DEPLOYED_LOCATION
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: USE_DEFAULT_LOCATION
The locaion to which the process flow is deployed.


Name: EXECUTION_LOCATION
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: NATIVE_EXECUTION
The location which is used to execute the process flow, which may differ from the deployment location.


Name: REMOTE_LOCATION
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: USE_DEFAULT_LOCATION
The File location which is remote from the Working Location, used by FTP to connect to the remote FTP server and set the remote working directory.


Name: USE_RETURN_AS_STATUS
Type: BOOLEAN
Valid Values: true, false
Default: false
When TRUE, the returned result will directly control the outcome of the activity/operator, 1=SUCCESS, 2=WARNINGS, 3=FAILURE.


Name: WORKING_LOCATION
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: USE_DEFAULT_LOCATION
The File location used to initialize the current working directory for an Operating System executable.

setReferenceIconSetClause

Set icon set for the process flow.

addProcessParameterClause

This clause adds the Parameters for a Process Flow.

addProcessVariableClause

Add a variable to the process flow.

addActivityClause

This clause adds the Activities for a Process Flow.

addTransitionClause

This clause adds the Transitions for a Process Flow.

addUserDefinedParameterClause

This clause adds the Parametrers for a User Defined Activity of a Process Flow.

propertyNameList

A comma delimited set of property names to set.

propertyValueList

A comma delimited set of property values to set.

addStandardActivityClause

This clause adds standard activity types AND, EJB, EMAIL, END_ERROR, END_WARNING, END_SUCCESS, FILE_EXISTS, FORK, FTP, JAVA, OR, ASSIGN, END_LOOP, FOR_LOOP, MANUAL, NOTIFICATION, OMBPLUS, ROUTE, SET_STATUS, SQLPLUS, WAIT, WHILE_LOOP OR USER_DEFINED to a Process Flow.

addMapActivityClause

This clause adds the MAP activity to a Process Flow.

addTemplateActivityClause

This clause adds an ACTIVITY_TEMPLATE as an activity to a Process Flow.

addDataAuditorActivityClause

This clause adds a DATA_AUDITOR activity to a Process Flow.

addFunctionActivityClause

This clause adds the Function or Procedure activity to a Process Flow.

addSubProcessActivityClause

This clause adds a Process as an activity to a Process Flow.

addWebServiceActivityClause

This clause adds a web service activity for a Process Flow.

propertyValue

Integer value, float value or quoted string literal.

collectPropertiesClause

This clause collects core properties of Map, Function/Procedure and Subprocess activity.

setPropertiesAndReferencesMapClauses

This clause sets reference to the existing Map.

setPropertiesAndReferencesTemplateClause

This clause sets reference to the existing activity template.

setPropertiesAndReferencesDataAuditorClauses

This clause sets reference to the existing data auditor.

setPropertiesAndReferencesFunctionClauses

This clause sets a reference to existing Function or Procedure.

setPropertiesAndReferencesSubProcessClauses

This clause sets a reference to existing Process Flow.

setPropertiesAndReferencesWebServiceClauses

This clause sets reference to the existing web service.

PROCESS_FLOW Object