SQL/MX Queuing and Publish/Subscribe Services
HP NonStop SQL/MX Queuing and Publish/Subscribe Services—523734-002
Index-1
Index
A
AFTER LAST ROW clause 2-8
Application logic checkpointing 2-18
ATTEMPT_ASYNCHRONOUS_ACCESS
default 2-2
Audited tables, support for 2-1
C
Channel
description of 1-3
example of B-1
Clustering key B-1
Concurrency 2-2, 2-11, B-2, B-11
Cursors
holdable 2-10, 2-11, B-11
limits 2-16
performance considerations for 4-1,
B-2
using to retrieve in priority order B-7
D
Data Access Manager (DAM) 2-16, B-2,
B-5
Database, shipping A-1
DECLARE CURSOR statement, example
of 2-11
Defaults 2-3
Dequeueing by priority, example of B-6
Dequeueing entries
using embedded DELETE 2-3/2-5
using embedded UPDATE 2-5/2-6
Dequeueing, description of 1-4
Destructive SELECTs 4-3
Dummy row, using 4-3
E
Embedded DELETE
cursor behavior B-7
example of 2-3, 3-3, B-5
join with primary key B-9
ordered stream B-6
performance considerations for 4-3
READ COMMITTED access B-5
referential integrity and 2-4
SELECT INTO use B-7
SKIP CONFLICT access B-5
Embedded UPDATE
example of 2-6, 3-4
performance considerations for 4-2
referential integrity and 2-6
SELECT INTO use B-8
Enqueueing 1-4, 2-2
Error
73 2-8
78 2-5
8006 2-3, 2-4, 2-5, 3-12, 4-1
8551 2-8
8553 2-16
Examples
invoices queue scenario B-5
/B-6
joining queues scenario B-8/B-9
joining queues, scenario description
for B-2
ordered stream scenario B-6/B-8
ordered stream scenario description
for B-1
queue, scenario description for B-1
quotes channel scenario B-2/B-4
shipping application B-9/B-12