Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBALTER QUEUE_PROPAGATION

Purpose

Alter the Queue Propagation by resetting its properties.

Prerequisites

Should be in the context of an Advanced Queue. The target Queue should exist in any Oracle Module.

Syntax

alterQPCommand =  OMBALTER ( QUEUE_PROPAGATION "QUOTED_STRING" ( 
          "renameClause" [ "alterQPPropertiesOrIconSetClause" ] | 
          "alterQPPropertiesOrIconSetClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterQPPropertiesOrIconSetClause =  SET ( "setQPPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) | UNSET "unsetReferenceIconSetClause"
     setQPPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterQPCommand

Alters the Queue Propagation with the given name by either renaming it or by setting it's properties or both.

renameClause

Renames the Queue Propagation to 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.

unsetReferenceIconSetClause

Unset the Icon Set.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

QUEUE_PROPAGATION Object

Table 4-6 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.