Using INSERT and SELECT

After a table is bound to a queue, 3use INSERT to insert items into the WMQ queue, and SELECT to retrieve 3WMQ messages.

Using the example with table vtimq above, 3the following example inserts a message into the msg column 3of VtiMQ and into the queue described by IDS.DEFAULT.SERVICE 3service and policy IDS.DEFAULT.POLICY:

INSERT into VtiMQ (msg) values ('PUT on queue with SQL INSERT');
31 row(s) inserted.

Use a SELECT statement to display the message:

SELECT * from VtiMQ;
3msg        PUT on queue with SQL INSERT
3correlid
3topic
3qname      IDS.DEFAULT.QUEUE
3msgid      AMQ
3msgformat  MQSTR