Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name QUEUE_SUBSCRIBER
Short Name QSU
View NameCI_QUEUE_SUBSCRIBERS
Description A subscriber to the implementation of a persistent or non-persistent
queue in an Oracle database
Sub-type of SECONDARY_ACCESS_ELEMENT
Versioning: Belongs to:
ORACLE_DATABASE versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: NAME
Used by: Oracle Designer

Underlying table:SDD_QSU

Reference Properties
Name Opt ? Notes Relationship In Arc
QUEUE_IMPLEMENTATION_REFERENCE N Prompt: Queue Implementation
Transferable only if null
Must be a subscriber to one and only one QUEUE_IMPLEMENTATION

Properties
Name Datatype Opt ? Notes Domain Default Value
ADDRESS VARCHAR2(1024) N Protocol specific address for the subscriber
Prompt: Address
NAME VARCHAR2(30) N Name of the subscriber
Prompt: Name
Uppercase
PROTOCOL NUMBER(38, 0) Y Protocol to interpret the address and propagate the message
Prompt: Protocol
RULE VARCHAR2(4000) Y Conditional expression based on the message properties
Prompt: Rule
APICONVERT_VARCHAR2(4000)
PARENT_IVID NUMBER(38, 0) Y Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed
System maintained
Updatable only if null
Defined on SAC supertype
PAC_REFERENCE NUMBER(38, 0) Y Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed
System maintained
Not updatable by user
Defined on SAC supertype

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

Other Properties
QUEUE_SUBSCRIBER 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:
  • 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_SUBSCRIBER:


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