OMBCREATE ADVANCED

Purpose

To create an Advanced Queue.

Prerequisites

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

Syntax

createAQCommand =  OMBCREATE ( ADVANCED_QUEUE "QUOTED_STRING" [ SET ( 
          "setPropertiesClause" [ SET "setReferenceIconSetClause" ] | 
          "setReferenceIconSetClause" ) ] )
     setPropertiesClause =  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

createAQCommand

Creates an Advanced Queue with the given name.

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.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

ADVANCED_QUEUE Object

Table 5-9 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

OMBCREATE ADVANCED_QUEUE