Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number 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 |