Use INSERT and SELECT
After a table is bound to a queue, use INSERT to insert items into the WMQ queue, and SELECT to retrieve WMQ messages.
Using the example with table vtimq above, the following
example inserts a message into the msg column of VtiMQ and
into the queue described by IDS.DEFAULT.SERVICE service and policy
IDS.DEFAULT.POLICY:
INSERT into VtiMQ (msg) values ('PUT on queue with SQL INSERT');
1 row(s) inserted.
Use a SELECT statement to display
the message:
SELECT * from VtiMQ;
msg PUT on queue with SQL INSERT
correlid
topic
qname IDS.DEFAULT.QUEUE
msgid AMQ
msgformat MQSTR