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

OMBALTER CONNECTOR

Purpose

Alter the connector by renaming it, and/or reset its referenced location or properties or icon set.

Prerequisites

Can be in any context; the name is a name of the connector's owning location and a connector name separated by slash.

Syntax

alterConnectorCommand =  OMBALTER ( CONNECTOR "QUOTED_STRING" ( 
          "renameClause" [ "alterPropertiesOrReferenceClause" ] | 
          "alterPropertiesOrReferenceClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrReferenceClause =  SET ( "setPropertiesClause" [ SET 
          "setReferenceClause" [ UNSET "unsetReferenceIconSetClause" ] | UNSET 
          "unsetReferenceIconSetClause" [ SET "setReferenceClause" ] ] | 
          "setReferenceClause" [ UNSET "unsetReferenceIconSetClause" ] ) | UNSET
           "unsetReferenceIconSetClause" [ SET "setReferenceClause" ]
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceClause =  ( "setReferenceToLocationClause" [ SET 
          "setReferenceIconSetClause" ] | "setReferenceIconSetClause" )
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setReferenceToLocationClause =  ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterConnectorCommand

Alter the connector specified by the quoted string. Connector name is specified as parent location name and a connector name separated by a '/' as follows: 'LOCATION_NAME/CONNECTOR_NAME'.

renameClause

Rename the connector.

alterPropertiesOrReferenceClause

Set the properties and/or reference location, and/or reference icon set of the connector.

setPropertiesClause

Set specified properties of the connector.

setReferenceClause

Set the reference location, and/or reference icon set of the connector.

unsetReferenceIconSetClause

Unset specified Icon Set.

propertyNameList

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

propertyNameList

Properties for CONNECTOR:

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

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

Name: DATABASE_LINK_NAME
Type: STRING(30)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Database Link name.

propertyValueList

The values for the named properties.

setReferenceToLocationClause

Set the name of the location which the connector references.

setReferenceIconSetClause

Set specified Icon Set.

propertyValue

A property value.

CONNECTOR Object

Table 1-10 CONNECTOR Object

Property Type Choices Min Max Default Description

DEPLOYABLE

BOOLEAN

true, false

none

none

true

Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true