Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

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 CONTROL_CENTER

Purpose

Alter the control center by renaming it, and/or reseting its properties, and/or adding/removing a referenced location, and/or resetting properties of a referenced location.

Prerequisites

Can be in any context.

Syntax

alterControlCenterCommand =  OMBALTER ( CONTROL_CENTER "QUOTED_STRING" ( 
          "renameClause" [ SET "setPropertiesClause" [ "alterIconSetClause" ] { 
          "alterReferenceLocationClause" } ] | SET "setPropertiesClause" [ 
          "alterIconSetClause" ] { "alterReferenceLocationClause" } | 
          "alterIconSetClause" { "alterReferenceLocationClause" } | { 
          "alterReferenceLocationClause" } ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     alterIconSetClause =  SET "setReferenceIconSetClause" [ UNSET 
          "unsetReferenceIconSetClause" ] | UNSET "unsetReferenceIconSetClause" 
          [ SET "setReferenceIconSetClause" ]
     alterReferenceLocationClause =  "addReferenceLocationClause" | 
          "modifyReferenceLocationClause" | "deleteReferenceLocationClause"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     addReferenceLocationClause =  ADD ( REF | REFERENCE ) LOCATION 
          "QUOTED_STRING" [ SET "setPropertiesClause" ]
     modifyReferenceLocationClause =  MODIFY ( REF | REFERENCE ) LOCATION 
          "QUOTED_STRING" SET "setPropertiesClause"
     deleteReferenceLocationClause =  DELETE ( REF | REFERENCE ) LOCATION 
          "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterControlCenterCommand

Alter a control center.

renameClause

Rename the control center to the value of the following quoted string.

setPropertiesClause

Set the specified properties of the control center.

alterIconSetClause

Set or unset the Icon Set.

alterReferenceLocationClause

Alter the referenced location.

propertyNameList

The names of the properties whose values you want to set.

propertyNameList

Properties for CONTROL_CENTER:

Name: HOST
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: N/A
The host machine the control center is installed on.

Name: PORT
Type: NUMBER
Valid Values: 1 - 65535
Default: 1521
The port number of the database in which the control center is installed.

Name: SERVICE_NAME
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: N/A
The service name of the database in which the control center is installed.

Name: USER
Synonym: USER_NAME
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: N/A
The name of the database user you wish to connect to the control center as.

Name: PASSWORD
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: N/A
The password.

Name: WORKSPACE
Type: STRING
Valid Values: Any valid character string in supported character set.
Default: N/A
The name of the workspace to which to connect.

All of the preceding properties (except of PASSWORD) are mandatory for OMBCREATE CONTROL_CENTER.

Basic properties for CONTROL_CENTER:

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

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

Properties for a referenced location of the control center:

Name: IS_SOURCE
Type: BOOLEAN
Valid Values: true, false
Default: true
If true, then a referenced location is a source location.

Name: IS_TARGET
Type: BOOLEAN
Valid Values: true, false
Default: true
If true, then a referenced location is a target location.

Name: CONNECTION_TYPE
Type: STRING
Valid Values: 'HOST_PORT_SERVICE', 'SQL_NET_CONNECTION'
Default: 'HOST_PORT_SERVICE'
The control center connection details format.

propertyValueList

The values for the named properties.

setReferenceIconSetClause

Set the icon set.

unsetReferenceIconSetClause

Unset the icon set.

addReferenceLocationClause

Add a referenced location to the control center and/or set its properties.

modifyReferenceLocationClause

Set/reset properties of the referenced location.

deleteReferenceLocationClause

Delete a referenced location from the control center.

propertyValue

A property value.

CONTROL_CENTER Object

Table 1-11 CONTROL_CENTER Object

Property Type Choices Min Max Default Description

CONNECTION_TYPE

STRING

HOST:PORT:SERVICE, SQL*NET Connection

none

none

HOST:PORT:SERVICE

Type of J2EE connection to use

DISPLAY_TYPE

STRING

none

none

none

CMPLocation_RuntimeRepository

Type of the location

HOST

STRING

none

none

none

empty string

Host of the location

NET_SERVICE_NAME

STRING(2000)

none

none

none

empty string

Net Service Name of the location

PASSWORD

STRING(30)

none

none

none

empty string

 

PLATFORM_NAME

STRING

none

none

none

empty string

Platform for the location.

PORT

NUMBER

none

none

none

1521

 

SCHEMA

STRING

none

none

none

empty string

Workspace owner.name to use for deployment

SERVICE_NAME

STRING

none

none

none

empty string

Service name of the web service activity

USER

STRING

none

none

none

empty string

 

VERSION

STRING

none

none

none

0

Version of the location