OMBRETRIEVE QUEUE_PROPAGATION

Purpose

Retrieve details of the Queue Propagation.

Prerequisites

Should be in the context of an Advanced Queue.

Syntax

retrieveQPCommand =  OMBRETRIEVE QUEUE_PROPAGATION "QUOTED_STRING" GET ( 
          "getQPPropertiesClause" | "getReferenceIconSetClause" )
     getQPPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveQPCommand

Retrieves the details of the Queue Propagation with the given name.

getQPPropertiesClause

Retrieves the values of the given Properties for the Queue Propagation with the given name.

getQPPropertiesClause

Basic properties for QUEUE_PROPAGATION: 

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

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

Name: TARGET_QUEUE
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Target Queue for the Queue Propagation. This has to be the name of a Queue existing in any Oracle Module.

getReferenceIconSetClause

Get the Icon Set.

propertyNameList

The list of properties.

QUEUE_PROPAGATION Object

Table 20-58 QUEUE_PROPAGATION 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.
DURATION	STRING	none	none	none	empty string	The duration of proagation to be done. The default value is null.Applicable only for non-streams queue propagation.
GENERATE_DBLINK	BOOLEAN	true, false	none	none	true	Generate script for Database Link which is used for propagation
GENERATE_QUEUE_PROPAGATION	BOOLEAN	true, false	none	none	true	Generate script for Queue Propagation
GENERATE_REPLICATION_RULE	BOOLEAN	true, false	none	none	false	Generate Ruleset and Rule for Replication purpose in Streams queue propagation
GENERATE_SCHEDULE_PROPAGATION	BOOLEAN	true, false	none	none	true	Generate script for Scheduling propagation. Applicable only for non-streams queue propagation.
GENERATION_COMMENTS	STRING	none	none	none	empty string	Enter additional comments for the generated code.
LATENCY	STRING	none	none	none	60	The latency for the queue propagation. By default the value is 60.Applicable only for non-streams queue propagation.
NEXT_TIME	STRING	none	none	none	empty string	Next time when the propagation to be done. The default value is null.Applicable only for non-streams queue propagation.
NOT_PERMITTED_TAG_VALUES	STRING	none	none	none	empty string	List of comma separated Tag values (in Hex numbers) which are not allowed for propagation
PERMITTED_TAG_VALUES	STRING	none	none	none	empty string	List of comma separated Tag values (in Hex numbers) which are allowed for propagation
START_TIME	STRING	none	none	none	SYSDATE	The start time for the propagation to happen. The default value is SYSDATE.Applicable only for non-streams queue propagation.
SUBCRIBER_TRANSFORMATION	STRING	none	none	none	empty string	A Transformation that will be applied before propagation to the target queue. Applicable only for non-streams queue propagation.
SUBSCRIBER_RULE_CONDITION	STRING	none	none	none	empty string	A Rule condition to check whether the message can be propagated to the subscriber. Applicable only for non-streams queue propagation.

OMBRETRIEVE QUEUE_PROPAGATION

Purpose

Prerequisites

Syntax

Parameters

retrieveQPCommand

getQPPropertiesClause

getQPPropertiesClause

getReferenceIconSetClause

propertyNameList

QUEUE_PROPAGATION Object

See Also