The Error Handler sample main message flow is supplied, but if you prefer to create the message flow yourself, follow the instructions below:
Palette drawers | Node type | Node name |
---|---|---|
WebSphere MQ | MQInput | STAFF_IN |
WebSphere MQ | MQOutput | STAFF_FAIL |
Routing | Filter | Check Valid Staff Number |
Database | Database | Update Staff Database |
Construction | Throw | Throw Exception |
WebSphere MQ | 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 |
Input Message Parsing | Message domain | XML : For XML messages | |
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;