Difference between revisions of "IX.AQ$STREAMS QUEUE TABLE S (view)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | IX.AQ$STREAMS_QUEUE_TABLE_S |- |} <pre> </pre>)
 
Line 7: Line 7:
 
|-
 
|-
 
|}
 
|}
 +
  
 
<pre>
 
<pre>
 
+
CREATE OR REPLACE SELECT queue_name QUEUE, name NAME , address ADDRESS , protocol PROTOCOL, trans_name TRANSFORMATION  FROM "AQ$_STREAMS_QUEUE_TABLE_S" s  WHERE (bitand(s.subscriber_type, 1) = 1)  WITH READ ONLY
 
</pre>
 
</pre>

Revision as of 21:02, 24 August 2009

wikibot

view IX.AQ$STREAMS_QUEUE_TABLE_S


CREATE OR REPLACE SELECT queue_name QUEUE, name NAME , address ADDRESS , protocol PROTOCOL, trans_name TRANSFORMATION  FROM "AQ$_STREAMS_QUEUE_TABLE_S" s  WHERE (bitand(s.subscriber_type, 1) = 1)  WITH READ ONLY