OMBCREATE CONNECTOR

Purpose

To create a connector.

Prerequisites

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

Syntax

createConnectorCommand =  OMBCREATE ( CONNECTOR "QUOTED_STRING" SET [ 
          "setPropertiesClause" SET ] "setReferenceToLocationClause" [ SET 
          "setReferenceIconSetClause" ] )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceToLocationClause =  ( REFERENCE | REF ) LOCATION 
          "QUOTED_STRING"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createConnectorCommand

Create a new connector. Connector name is specified as parent ___location name and a connector name separated by a slash as follows: 'LOCATION_NAME/NEW_CONNECTOR_NAME'.

setPropertiesClause

Set specified properties of the connector.

setReferenceToLocationClause

Set the name of the ___location which the connector references.

setReferenceIconSetClause

Set 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.

propertyValue

A property value.

CONNECTOR Object

Table 6-9 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