Examples

Example 1: 3

begin;
3EXECUTE FUNCTION MQReceive();
3commit;

Alternatively, the following syntax can be used: 3

insert into my_order_table VALUES(MQReceive());

This example receives the message at the head of the queue with 3the following parameters: 3

3
• service_name: default service name
3
• policy_name: default policy name
3
• correl_id: none

Example 2: 3

begin;
3EXECUTE FUNCTION MQReceive('MYSERVICE');
3rollback;

Alternatively, the following syntax can be used: 3

insert into my_order_table VALUES(MQReceive('MYSERVICE'));

This example receives the message at the head of the queue with 3the following parameters: 3

3
• service_name: "MYSERVICE"
3
• policy_name: default policy name
3
• correl_id: none

Example 3: 3

begin;
3EXECUTE FUNCTION MQReceive('MYSERVICE','MYPOLICY');
3commit;

Alternatively, the following syntax can be used: 3

insert into my_order_table VALUES(MQReceive('MYSERVICE', 'MYPOLICY'));

This example receives the message at the head of the queue with 3the following parameters: 3

3
• service_name: "MYSERVICE"
3
• policy_name: "MYPOLICY"
3
• correl_id: none

Example 4: 3

begin;
3EXECUTE FUNCTION MQReceive('MYSERVICE','MYPOLICY','1234');
3commit;

Alternatively, the following syntax can be used: 3

insert into my_order_table VALUES(MQReceive('MYSERVICE', 'MYPOLICY', '1234'));

This example receives the message at the head of the queue with 3the following parameters: 3

3
• service_name: "MYSERVICE"
3
• policy_name: "MYPOLICY"
3
• correl_id: "1234"