SQL/MX Queuing and Publish/Subscribe Services

Hewlett-Packard Company—523734-002
i
HP NonStop SQL/MX Queuing
and Publish/Subscribe Services
Index Examples Tables
What’s New in This Manual v
Manual Information v
New and Changed Information v
About This Manual vii
Audience vii
Related Documentation vii
Notation Conventions xi
1. Introduction
What Is Publish/Subscribe? 1-1
Why Use Publish/Subscribe? 1-1
Terminology 1-3
Traditional Implementation of Publish/Subscribe 1-4
SQL/MX Implementation of Publish/Subscribe 1-4
Concepts 1-5
Support for SQL/MP and SQL/MX Tables 1-5
Major Features 1-5
Comparing Triggers and Publish/Subscribe 1-6
2. Major Queuing Features
Stream Access 2-2
Stream Timeout Attribute 2-3
Embedded DELETE 2-3
Embedded UPDATE 2-5
Skip Conflict Access 2-7
AFTER LAST ROW 2-8
Set Column Values On Rollback 2-9
Holdable Cursors 2-10
Rowset Integration 2-12
Partitioned Queues 2-13