Examples

Example 1: The following table contains sample rows and 3columns in the "informix".mqipubsub table. 3

3

begin;
3EXECUTE FUNCTION MQSubscribe('IDS.DEFAULT.SUBSCRIBER', 
3   'IDS.DEFAULT.PUB.SUB.POLICY', 'Weather');
3commit;

The above statement demonstrates a subscriber registering an 3interest in messages containing the topic "Weather" with the following 3parameters: 3

3
• subscriber_name: "IDS.DEFAULT.SUBSCRIBER"
3
• policy_name: "IDS.DEFAULT.PUB.SUB.POLICY"
3
• topic: "Weather"

begin;
3EXECUTE FUNCTION MQPublish('IDS.DEFAULT.PUBLISHER', 
3'IDS.DEFAULT.PUB.SUB.POLICY', 'Rain', 'Weather');
3commit;

The above statement publishes the message with the following 3parameters: 3

3
• publisher_name: "IDS.DEFAULT.PUBLISHER"
3
• policy_name: "IDS.DEFAULT.PUB.SUB.POLICY"
3
• msg_data: "Rain"
3
• topic: "Weather"
3
• correl_id: none

begin;
3EXECUTE FUNCTION MQReceive('IDS.DEFAULT.SUBSCRIBER.RECEIVER', 
3'IDS.DEFAULT.PUB.SUB.POLICY');
3commit;

The above statement receives the message with the following parameters 3(it returns "Rain"): 3

3
• service_name: "IDS.DEFAULT.SUBSCRIBER.RECEIVER"
3
• policy_name: "IDS.DEFAULT.PUB.SUB.POLICY"

Example 2: 3

begin;
3EXECUTE FUNCTION MQSubscribe('Weather');
3commit;

This example demonstrates a subscriber registering an interest 3in messages containing the topic "Weather" with the following parameters: 3

3
• subscriber_name: default subscriber
3
• policy_name: default policy
3
• topic: "Weather"

Example 3: 3

begin;
3EXECUTE FUNCTION MQSubscribe('PORTFOLIO-UPDATES', 'BASIC-POLICY', 'Stocks:Bonds');
3commit;

This example demonstrates a subscriber registering an interest 3in messages containing the topics "Stocks" and "Bonds" with the 3following parameters: 3

3
• subscriber_name: "PORTFOLIO-UPDATES"
3
• policy_name: "BASIC-POLICY"
3
• topic: "Stocks", "Bonds"