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