Examples

Example 1: 3

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

Alternatively, the following syntax can be used: 3

insert into my_order_table VALUES(MQRead());

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

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

Example 2: 3

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

Alternatively, the following syntax can be used: 3

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

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

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

Example 3: 3

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

Alternatively, the following syntax can be used: 3

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

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

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

Example 4: 3

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

Alternatively, the following syntax can be used: 3

insert into my_order_table VALUES(MQRead('MYSERVICE', 'MYPOLICY', 'TESTS'));

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

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