SQL/MX Queuing and Publish/Subscribe Services

Contents
HP NonStop SQL/MX Queuing and Publish/Subscribe Services—523734-002
ii
3. Embedded SQL Examples
Ordered Streams 2-14
Index Requirements 2-14
Order by a Column Value 2-14
Order by the SYSKEY Value 2-15
Joins 2-15
Run-Time Limits on Streams 2-16
Restarting a Subscriber 2-17
Destructive Subscribers 2-17
Nondestructive Subscribers 2-17
3. Embedded SQL Examples
Stream Access 3-2
Embedded DELETE 3-3
Embedded UPDATE 3-4
Skip Conflict Access 3-5
Set Column Values on Rollback 3-6
Rowset Integration 3-7
Join With a Stream 3-8
Managing Transactions With the Stream Timeout Attribute 3-10
4. Performance Considerations
Considerations for Partitions 4-1
Considerations for Cursors 4-1
Considerations for Embedded UPDATEs 4-2
Considerations for Rowsets 4-3
Considerations for Embedded DELETEs 4-3
Considerations for MATERIALIZE, Joins, and Streams 4-4
A. The Shipping Database
B. Examples
Typical User Scenarios B-1
Scenario 1. The Quotes Channel B-2
The Quotes Table B-2
Subscribing to Quotes B-3
Scenario 2. The Invoices Queue B-5
The Invoices Table B-5
Dequeueing Invoices B-5