OMBRETRIEVE QUEUE_TABLE

Purpose

Retrieve details of the Queue Table.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

retrieveQTCommand =  OMBRETRIEVE QUEUE_TABLE "QUOTED_STRING" ( GET 
          "getQTPropertiesClause" )
     getQTPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveQTCommand

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

getQTPropertiesClause

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

getQTPropertiesClause

Basic properties for QUEUE_TABLE: 

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

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

Name: PAYLOAD_TYPE
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Object Type for the Queue Table. This has to be the name of an Object Type  (OBJECT_TYPE) existing in any Oracle Module.

propertyNameList

The list of properties.

QUEUE_TABLE Object

Table 20-59 QUEUE_TABLE 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.
GENERATE_QUEUE_TABLE	BOOLEAN	true, false	none	none	true	Generate code to create the queue table that will persist the messages of this Advanced Queue.
GENERATION_COMMENTS	STRING	none	none	none	empty string	Enter additional comments for the generated code.
TABLESPACE	STRING(30)	none	none	none	empty string

OMBRETRIEVE QUEUE_TABLE

Purpose

Prerequisites

Syntax

Parameters

retrieveQTCommand

getQTPropertiesClause

getQTPropertiesClause

propertyNameList

QUEUE_TABLE Object

See Also