| Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 | 
 | 
| 
 | Mobi · ePub | 
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.
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" )
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.
Add a referenced location to the control center and/or set its properties.
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 |