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

See Also

OMBALTER

OMBCREATE CONNECTOR

OMBDROP CONNECTOR