Selecting Queue Subscribers and Their Rules

Figure 10-13 Use Case Diagram: Selecting Queue Subscribers and their Rules

Text description of the illustration adq10qvw18.gif

Name of View

AQ$<queue_table_name>_R

Purpose

This view displays only the rule based subscribers for all queues in a given queue table including the text of the rule defined by each subscriber. This is a view of subscribers with rules defined on any queues of a given queue table. This view is generated when the queue table is created and is called aq$<queue_table_name>_r. It is used to query subscribers for any or all the queues in this queue table. Note that this view is only created for 8.1-compatible queue tables. The view will also display the transformation for the subscriber if one was specified.

Table 10-13 AQ$<queue_table_name>_R

Column Name & Description	Null?	Type
QUEUE--name of Queue for which subscriber is defined	NOT NULL	VARCHAR2(30)
NAME--name of Agent		VARCHAR2(30)
ADDRESS--address of Agent		VARCHAR2(1024)
PROTOCOL--protocol of Agent		NUMBER
RULE--text of defined rule		VARCHAR2(30)
TRANSFORMATION--name of transformation specified, can be null		VARCHAR2(61)