SQL/MX Queuing and Publish/Subscribe Services

The Shipping Database
HP NonStop SQL/MX Queuing and Publish/Subscribe Services—523734-002
A-2
SET SCHEMA PSDB.pubs;
INSERT INTO inbox (destination, origin, seqnbr, priority)
VALUES (200, 100, 01, 1),
(201, 101, 02, 3),
(201, 101, 03, 5),
(202, 102, 04, 2),
(231, 101, 05, 4),
(233, 104, 06, 1),
(235, 102, 07, 5),
(237, 103, 08, 2),
(263, 104, 09, 2),
(262, 102, 10, 3),
(261, 101, 11, 4),
(261, 103, 12, 1);
INSERT INTO routes
VALUES (101, 201, 300),
(104, 263, 302),
(102, 262, 301),
(101, 231, 302),
(102, 202, 303);
INSERT INTO channel
VALUES (200, 100, 1),
(201, 101, 3),
(201, 101, 5),
(202, 102, 2),
(231, 101, 4),
(233, 104, 1),
(235, 102, 5),
(237, 103, 2),
(263, 104, 2),
(262, 102, 3),
(261, 101, 4),
(261, 103, 1);
-------------------------------------------------------------