The "informix".mqipubsub table

The "informix".mqipubsub table has the policy definitions for the following attributes:

• Distribution list
• Receive
• Subscriber
• Publisher

The "informix".mqipubsub table has the following schema:

CREATE TABLE "informix".mqipubsub
    pubsubname      LVARCHAR(256) NOT NULL UNIQUE, 
    servicebroker   LVARCHAR(256),                  
    receiver        LVARCHAR(256) default ' ', 
    psstream        LVARCHAR(256) default ' ',
    pubsubtype      VARCHAR(20) CHECK (pubsubtype IN ('Publisher', 'Subscriber')),
FOREIGN KEY (servicebroker) REFERENCES "informix".mqiservice(servicename));

The attributes are defined as follows:

pubsubname

is the name of the publish/subscribe service.

servicebroker

The service name of the publish/subscribe service.

receiver

The queue on which to receive messages after subscription.

psstream

The stream coordinating the publish/subscribe service.

pubsubtype

The service type.