用于设置服务器与 WMQ 一起使用的样本代码

以下示例显示如何为 MQ 设置数据库服务器：

1. 打开 DB-Access 与 stores_demo 数据库。
2. 运行以下命令：

   -- Service for most operations
   
   INSERT INTO mqiservice
            (servicename, queuemanager, queuename)
     VALUES ('lser.qm1', 'lqm1', 'IDS.DEFAULT.QUEUE');
   
   -- Service for publishing
   
   INSERT INTO mqiservice
            (servicename, queuemanager, queuename)
     VALUES ('lpubser.qm1', 'lqm1', 'SYSTEM.BROKER.DEFAULT.STREAM');
   
   -- service for subscribing
   INSERT INTO mqiservice
            (servicename, queuemanager, queuename, mqchllib, mqchltab)
     VALUES ('lsubser.qm1', 'lqm1', 'SYSTEM.BROKER.CONTROL.QUEUE');
       
   -- service for receiving subscribe message
   INSERT INTO mqiservice
            (servicename, queuemanager, queuename, mqchllib, mqchltab)
   VALUES ('lrecsubser.qm1', 'lqm1',
                   'IDS.DEFAULT.SUBSCRIBER.RECEIVER.QUEUE');
   
   -- subscriber information
   INSERT INTO mqipubsub
            (pubsubname, servicebroker, receiver,psstream,pubsubtype)
     VALUES ('lsub.qm1', 'lsubser.qm1', 'lrecsubser.qm1',
                             'SYSTEM.BROKER.DEFAULT.STREAM', 'Subscriber');
   
   -- publisher information
   INSERT INTO mqipubsub
            (pubsubname, servicebroker, receiver,psstream, pubsubtype)
     VALUES ('lpub.qm1', 'lpubser.qm1', '', '', 'Publisher');