retrieveQTCommand = OMBRETRIEVE QUEUE_TABLE "QUOTED_STRING" ( GET
"getQTPropertiesClause" )
getQTPropertiesClause = PROPERTIES "(" "propertyNameList" ")"
propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
Retrieves the values of the given Properties for the Queue Table with the given name.
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.
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 |