OMBCREATE QUEUE_PROPAGATION

Purpose

To create a Queue Propagation.

Prerequisites

Should be in the context of an Advanced Queue or Streams Queue. The Target Queue can exist in any Oracle Module.

Syntax

createQPCommand =  OMBCREATE ( QUEUE_PROPAGATION "QUOTED_STRING" [ SET ( 
          "setQPPropertiesClause" [ SET "setReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) ] )
     setQPPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createQPCommand

Creates a Queue Propagation with the given name.

setQPPropertiesClause

Sets properties (core, logical, physical, user-defined) for Queue Propagation. Valid properties are shown below:

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.

setReferenceIconSetClause

Set the specified Icon Set.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

QUEUE_PROPAGATION Object

Table 9-51 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.