| Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 | 
 | 
| 
 | Mobi · ePub | 
retrieveControlCenterCommand =  OMBRETRIEVE CONTROL_CENTER "QUOTED_STRING" 
          ( "retrieveControlCenterClause" | "getReferenceIconSetClause" | 
          "retrieveReferenceLocationClause" )
     retrieveControlCenterClause =  "getPropertiesClause" | GET 
          "getReferenceLocationsClause"
     getReferenceIconSetClause =  GET ( REF | REFERENCE ) ICONSET
     retrieveReferenceLocationClause =  GET ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING" "getPropertiesClause"
     getPropertiesClause =  GET PROPERTIES "(" "propertyNameList" ")"
     getReferenceLocationsClause =  ( REFERENCE | REF ) LOCATIONS
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
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.
Table 18-4 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 |