SQL/MX Queuing and Publish/Subscribe Services

Index
HP NonStop SQL/MX Queuing and Publish/Subscribe Services—523734-002
Index-3
S
S
Scenarios
invoices queue B-5/B-6
joining queues B-8/B-9
ordered stream B-6/B-8
quotes channel B-2/B-4
shipping application B-9/B-12
SELECT INTO statement, example of B-7
SELECTs, destructive 1-5
Semi-queuing, description of 1-4
SET ON ROLLBACK clause
description of 2-1, 2-9
example of 2-9, 3-6
Shipping database A-1
SKIP CONFLICT access
description of 2-7
example of 3-5, B-5
mode 1-5
SQL/MP and SQL/MX table support 1-5
Stream access
description of 1-3, 2-2, B-1, B-3
example of 2-2, 3-2, B-3
insertion order retrieval B-3
resuming after disconnect B-3
run-time limits 2-16
subset using WHERE clause B-4
Streams
definition of 1-5
join with 3-8
overflow condition 2-16
run-time limits 2-16
termination of 2-2
Streams, ordered
description of 2-14
example of 2-14
secondary index requirements 2-14
STREAM_TIMEOUT attribute
default value 2-3
example of 2-3, 3-10/3-15
Subscribers
destructive 2-17
nondestructive 2-17
restarting 2-17/2-18
Subscribing
description of 1-3
example of B-1
Support for SQL/MP and SQL/MX
tables 1-5
SYSKEY B-2
T
Tables
nonaudited not supported 2-1
support for audited 2-1
support for SQL/MP and SQL/MX 1-5
Transactional queuing 2-7
Transactions
limiting the duration of 4-1
managing with
STREAM_TIMEOUT 3-10/3-15
Triggers 1-6/1-7
W
WITH HOLD clause
concurrency and performance B-2
example of 2-10
usage note B-4
Work_pending column 4-2