Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | QUEUE_TABLE_DEFINITION |
| Short Name | QTD |
| View Name | CI_QUEUE_TABLE_DEFINITIONS |
| Description | A queue table is a database table, based on an Oracle type or a scalar |
| type, that can contain one or more queues. | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of QUEUE_TABLE_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_QTD |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ORACLE_TYPE_REFERENCE | Y | Prompt: Oracle Type | May be referencing one and only one ORACLE_TYPE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| AUTO_COMMIT_FLAG | VARCHAR2(1) | N | Indicates whether messages are to be committed automatically. "Default" indicates the database default is to be used
Prompt: Auto Commit ? Uppercase | YESNODEF | D |
| COMPATIBLE_DB_VERSION | VARCHAR2(10) | Y | Lowest database version with which the queue is compatible
Prompt: Compatible Database Version | ||
| DATATYPE | VARCHAR2(16) | Y | Scalar datatype for this queue table, if not defined via an Oracle type.
Prompt: Scalar Datatype Uppercase | QT_SCALAR_DATATYPE | |
| DATATYPE_DEFINED_BY | VARCHAR2(9) | N | Logical arc discriminator property between ORACLE_TYPE_REFERENCE and the DATATYPE property. Both of these are optional, but one of them MUST be specified
Not displayed Uppercase System maintained Not updatable by user | QT_DATATYPE_DEFINED_BY | |
| MESSAGE_GROUPING | VARCHAR2(13) | Y | Message grouping behaviour for queues created in this queue table
Prompt: Message Grouping Uppercase | QT_MESSAGE_GROUPING | |
| MULTIPLE_CONSUMERS_FLAG | VARCHAR2(1) | N | Indicates whether the queue table will be used by a single or multiple consumers. "Default" indicates the database default should be used
Prompt: Multiple Consumers ? Uppercase | YESNODEF | D |
| NAME | VARCHAR2(30) | N | Name of this queue table
Prompt: Name Uppercase | ||
| PRIMARY_INSTANCE | NUMBER(38, 0) | Y | Applicable to OPS environments only. Primary instance in which queue monitor scheduling and propagation for the queues in the queue table will be done
Prompt: Primary Instance | ||
| REMARK | VARCHAR2(2000) | Y | A brief comment about this queue table
Prompt: Comment | ||
| SECONDARY_INSTANCE | NUMBER(38, 0) | Y | Applicable to OPS environments only. Secondary instance to be used if the primary instance is not available
Prompt: Secondary Instance | ||
| SORT_LIST | VARCHAR2(16) | Y | Columns of the queue table, in ascending order, to be used as the sort key. The columns of a queue table are not modelled as COLUMNs, hence their specification here using a domain of valid values
Prompt: Sort List Uppercase | QT_SORT_LIST | |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| HELP | CDHELP | User/Help Text |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| QUEUE_TABLE_DEFINITION has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference QUEUE_TABLE_DEFINITION:
Note: