The Error Handler sample main message flow is supplied, but if you prefer to create the message flow yourself, follow the instructions below:
Node type | Node name |
---|---|
MQInput | STAFF_IN |
MQOutput | STAFF_FAIL |
Filter | Check Valid Staff Number |
Database | Update Staff Database |
Throw | Throw Exception |
MQOutput | STAFF_OUT |
Node name | Terminal | Connect to this node |
---|---|---|
STAFF_IN | Out | Error_Handler |
Failure | STAFF_FAIL | |
Error Handler | Out | Check Valid Staff Number |
Check Valid Staff Number | False | Throw Exception |
True | Update Staff Database | |
Update Staff Database | Out | STAFF_OUT |
Node name | Page | Property | Value |
---|---|---|---|
STAFF_IN | Basic | Queue Name | STAFF_IN |
Default | Message Domain | XML | |
STAFF_FAIL | Basic | Queue Name | STAFF_FAIL |
Advanced | Transaction Mode | Yes | |
Update Staff Database | Basic | Data Source | STAFFDB |
Throw Exception | Basic | Message Number | 3001 |
Basic | Message Text | Invalid staff number | |
STAFF_OUT | Basic | Queue Name | STAFF_OUT |
Advanced | Transaction Mode | Yes |
CREATE FILTER MODULE Main_Flow_Filter CREATE FUNCTION Main() RETURNS BOOLEAN BEGIN If Body.Staff.StaffNumber<='10' THEN RETURN TRUE; ELSE RETURN FALSE; END IF; END; END MODULE; CREATE DATABASE MODULE Main_Flow_Database CREATE FUNCTION Main() RETURNS BOOLEAN BEGIN INSERT INTO Database.STAFF(STAFFNUM, LASTCHANGE, FIRSTNAME, LASTNAME) VALUES(Body.Staff.StaffNumber, CURRENT_TIMESTAMP, Body.Staff.NameInfo.FirstName, Body.Staff.NameInfo.LastName); RETURN TRUE; END; END MODULE;