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

OMBCREATE CDC_CT

Purpose

To create a CDC Code Template.

Prerequisites

In the context of an CT module.

Syntax

createJCTCommand =  OMBCREATE CDC_CT "QUOTED_STRING" { 
          "kmCreateOptionsOptionsClause" }
     kmCreateOptionsOptionsClause =  SET "setReferenceIconSetClause" | SET 
          "setPropertiesClause" | ADD ( "addParameterClause" | 
          "addVariableClause" | "addCTTaskClause" | "addNestedCTTaskClause" | 
          "addTransitionClause" )
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     addParameterClause =  PARAMETER "QUOTED_STRING" [ OF TASK "QUOTED_STRING" ]
           [ SET "setPropertiesClause" ] [ "parameterBindingClause" ]
     addVariableClause =  VARIABLE "QUOTED_STRING" [ SET "setPropertiesClause" ]
     addCTTaskClause =  "TASK_TYPE" TASK "QUOTED_STRING" { 
          "kmTaskAddOptionsOptionsClause" }
     addNestedCTTaskClause =  NESTED_CT TASK "QUOTED_STRING" SET [ 
          "collectPropertiesClause" SET ] ( REF | REFERENCE ) CT "QUOTED_STRING"
           [ SET "setReferenceIconSetClause" ]
     addTransitionClause =  TRANSITION "QUOTED_STRING" FROM TASK "QUOTED_STRING"
           TO "QUOTED_STRING" [ SET "setPropertiesClause" ]
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     parameterBindingClause =  UNBIND | BIND TO ( "parameterLocator" | 
          "variableLocator" )
     kmTaskAddOptionsOptionsClause =  SET "setReferenceIconSetClause" | UNSET 
          "unsetReferenceIconSetClause" | SET "setPropertiesClause"
     collectPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "("
           "propertyValueList" ")"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     parameterLocator =  PARAMETER "QUOTED_STRING" [ OF TASK "QUOTED_STRING" ]
     variableLocator =  VARIABLE "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET

Parameters

createJCTCommand

Creates a CDC CT. The following code template will be created by default:

{0}

setReferenceIconSetClause

Set icon set for the expert module.

setPropertiesClause

This clause sets properties for the corresponding object.

setPropertiesClause

Basic properties for Code Template: 

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

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

Basic properties for TASK: 

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

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

addParameterClause

Add a parameter to the expert or one of it's tasks.

addVariableClause

Add a variable to the expert.

addTransitionClause

Add a transition to the expert.

propertyNameList

The list of property names.

propertyValueList

The list of property values being set.

parameterBindingClause

Bind or unbind two parameters. Note that this is setting the binding attribute of the parameter object and is not necessarily the same as the direction of data flow. The parameter to be set should be the one whose binding attribute is modified via the Object Inspector in the expert editor.

collectPropertiesClause

This clause sets properties for the corresponding object.

propertyValue

Value of a property.

parameterLocator

Specify a parameter, either one of the expert or of a task.

variableLocator

Specify a variable in the expert.

CDC_CT Object

Table 6-7 CDC_CT Object

Property Type Choices Min Max Default Description

CONSISTENT_SET

BOOLEAN

true, false

none

none

false

Is the change data capture operator on a consistent set of tables?

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

PLATFORM

STRING

none

none

none

GENERIC

 

SOURCE_PLATFORM

STRING

none

none

none

GENERIC