Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name QUEUE
Short Name QUE
View NameCI_QUEUES
Description An Oracle queue is a repository for messages, and may be persistent or
non-persistent
A persistent queue is stored in the database in a queue table whereas
a non-persistent queue allows the sending of messages only to
subscribers and explicity specified recipients who are local.
Sub-type of SHAREABLE_ELEMENT
Non-instantiable super-type of NON_PERSISTENT_QUEUE
PERSISTENT_QUEUE
As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc
Underlying table:SDD_QUE

Reference Properties
Name Opt ? Notes Relationship In Arc

Properties
Name Datatype Opt ? Notes Domain Default Value
NAME VARCHAR2(30) N Name of the queue
Prompt: Name
Uppercase
QUEUE_SUBTYPE VARCHAR2(3) N Sub-type discriminator. Internal system maintained property indicating the QUEUE subtype
Not displayed
Uppercase
System maintained
Not updatable by user
QUEUE_SUBTYPE
REMARK VARCHAR2(2000) Y A brief comment about this queue
Prompt: Comment

Multi-line Text
Name Text Type Prompt
DESCRIPTION CDIDSC Description
HELP CDHELP User/Help Text
NOTES CDINOT Notes

Other Properties
The following 'standard' properties are also inherited by all element types:
  • ID
  • IRID
  • IVID
  • ELEMENT_TYPE_NAME
  • DATE_CREATED
  • CREATED_BY
  • DATE_CHANGED
  • CHANGED_BY
  • NUMBER_OF_TIMES_MODIFIED
  • TYPES

Other element types that reference QUEUE:


Note:

  • All properties are displayed and updatable by the user unless indicated otherwise
  • All reference properties are displayed and transferable unless indicated otherwise
  • All domains are enforced unless indicated otherwise
  • All properties and reference properties are defined on this element type unless indicated as inherited from a supertype