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

Part Number 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 ADVANCED_QUEUE

Purpose

Alter the Advanced Queue by resetting its properties.

Prerequisites

Should be in the context of an Oracle Module. The Queue Table should exist in the same Oracle Module.

Syntax

alterAQCommand =  OMBALTER ( ADVANCED_QUEUE "QUOTED_STRING" ( 
          "renameClause" [ "alterPropertiesOrIconSetClause" ] | 
          "alterPropertiesOrIconSetClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  SET ( "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) | UNSET "unsetReferenceIconSetClause"
     setPropertiesClause =  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

alterAQCommand

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

renameClause

Renames the Advanced Queue to the given name.

alterPropertiesOrIconSetClause

Set properties or change the Icon Set.

setPropertiesClause

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

getPropertiesClause

Basic properties for ADVANCED_QUEUE: 

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

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

Name: QTABLE
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Queue Table for the Advanced Queue. This has to be the name of a Queue Table(QUEUE_TABLE) existing in the same 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.

ADVANCED_QUEUE Object

Table 1-2 ADVANCED_QUEUE Object

Property Type Choices Min Max Default Description

DEPLOYABLE

BOOLEAN

true, false

none

none

true

 

DEQUEUE_ENABLED

BOOLEAN

true, false

none

none

true

 

ENQUEUE_ENABLED

BOOLEAN

true, false

none

none

true

 

GENERATE_ADVANCED_QUEUE

BOOLEAN

true, false

none

none

true

 

GENERATE_TEMPORARY_TABLE

BOOLEAN

true, false

none

none

true

 

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

MAX_RETRIES

NUMBER

none

none

none

5

 

RETENTION_TIME

NUMBER

none

none

none

0

 

RETRY_DELAY

NUMBER

none

none

none

0