OMBRETRIEVE CONNECTOR

Purpose

Retrieve details from a connector.

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

retrieveConnectorCommand =  OMBRETRIEVE CONNECTOR "QUOTED_STRING" ( 
          "getPropertiesClause" | "getReferencedLocationClause" | 
          "getReferenceIconSetClause" )
     getPropertiesClause =  GET PROPERTIES "(" "propertyNameList" ")"
     getReferencedLocationClause =  GET ( REF | REFERENCE ) LOCATION
     getReferenceIconSetClause =  GET ( REF | REFERENCE ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveConnectorCommand

Retrieve details from the named connector.

getPropertiesClause

Get properties of the connector.

getReferencedLocationClause

Get the name of the ___location which the connector references.

getReferenceIconSetClause

Get the referenced 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.

CONNECTOR Object

Table 18-3 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

OMBRETRIEVE