Use the following instructions to create the SimplifiedDBRouting message flow. For more detailed instructions, click the links provided at the end of each step.
To create and configure the SimplifiedDBRouting message flow:
Palette drawers | Node type | Node name (MQ Queue) |
---|---|---|
WebSphere MQ | MQInput | MQInput |
WebSphere MQ | MQOutput | FailureQ |
WebSphere MQ | MQOutput | KeyNotFoundQ |
WebSphere MQ | MQOutput | OrderClockQ |
WebSphere MQ | MQOutput | SeniorStaffQ |
WebSphere MQ | MQOutput | DefaultQ |
Routing | Route | Route |
Database | DatabaseRetrieve | DatabaseRetrieve |
Database | DatabaseRoute | DatabaseRoute |
Construction | Trace | Trace |
Node name | Terminal | Connect to this node |
---|---|---|
MQInput | Out | Route |
Failure | Trace | |
Catch | Trace | |
Route | Default | DatabaseRetrieve |
Failure | Trace | |
Match | DatabaseRoute | |
DatabaseRetrieve | Out | DatabaseRoute |
Failure | Trace | |
KeyNotFound | KeyNotFoundQ | |
DatabaseRoute | KeyNotFound | KeyNotFoundQ |
Failure | Trace | |
TenYearsService | OrderClockQ | |
OlderThanMe | SeniorStaffQ | |
Default | DefaultQ | |
Trace | Out | FailureQ |
Node name | Page | Property | Value | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MQInput | Basic | Queue name | SIMPLERROUTEDB_IN This property is the local queue from which the message flow takes the message. |
||||||||||||||||||||||||||||||||||
Input Message Parsing | Message domain | XMLNSC : For XML messages This property tells the broker to use the XMLNSC parser, which is namespace aware, supports validation, and has low memory usage. |
|||||||||||||||||||||||||||||||||||
Route | Basic | Filter pattern | $Body/EmpRecord/WorkDept This property is an XPath 1.0 expression, specifying in this case a path location to an expected element within the input message to this node. The node attempts to find a work department field, and if not present resolves to false. |
||||||||||||||||||||||||||||||||||
Basic | Routing output terminal | Match |
|||||||||||||||||||||||||||||||||||
DatabaseRetrieve | Basic | Data source name | SIMPLERROUTEDB |
||||||||||||||||||||||||||||||||||
Basic | Copy message | Yes This property indicates that a copy of the original incoming message is required, because the message tree is to be updated. |
|||||||||||||||||||||||||||||||||||
Basic | Query elements |
SELECT E.LASTNM, E.FIRSTNM, E.YEARSSERVICE, E.AGEINYRS, E.WORKDEPT FROM EMPLOYEE E WHERE E.EMPNUM = ? ORDER BY E.LASTNM ASC, E.FIRSTNM ASC, E.YEARSSERVICE ASC, E.AGEINYRS ASC, E.WORKDEPT ASC |
|||||||||||||||||||||||||||||||||||
Data Element Table | Data elements |
If the location does not exist in the output message (a copy of the input message), it is created. Because the default value for basic property Multiple rows is set to No, only the values returned in the first row of a result set are processed by this node. The result set is obtained by running the query specified in the SQL statement window and configured by using the basic Query elements table content. |
|||||||||||||||||||||||||||||||||||
DatabaseRoute | Basic | Data source name | SIMPLERROUTEDB |
||||||||||||||||||||||||||||||||||
Basic | Query elements |
SELECT M.EMPNUM, M.LASTNM, M.AGEINYRS FROM EMPLOYEE M, DEPARTMENT D WHERE D.DEPTNUM = ? AND D.MGRNUM = M.EMPNUM ORDER BY M.EMPNUM ASC, M.LASTNM ASC, M.AGEINYRS ASC |
|||||||||||||||||||||||||||||||||||
Basic | Distribution mode | All This property determines the routing behavior of this node when an inbound message matches multiple expressions. If Distribution mode is set to First, the message is propagated to the first matching output terminal. If Distribution mode is set to All, the message is propagated to all matching output terminals. If there is no matching output terminal, the message is sent to the Default terminal. |
|||||||||||||||||||||||||||||||||||
Filter Expression Table | Filter table |
Each expression is cast as a Boolean. If the expression resolves to true, the node propagates the input message to the dynamic output terminal that is specified for the Routing output terminal value of the row. Note: This terminal must first be created by right-clicking on this node and clicking Add Output Terminal. For instructions, see Using dynamic terminals in the WebSphere Message Broker documentation. |
|||||||||||||||||||||||||||||||||||
Trace | Basic | Destination | Local Error Log This property instructs the node to write the trace information to the local error log. On Windows, the local error log is Event Viewer; on Linux, the local error log is syslog. |
||||||||||||||||||||||||||||||||||
Basic | Pattern |
Root > ${Root}The trace pattern extracts the entire message tree information. |
|||||||||||||||||||||||||||||||||||
Basic | Message number | 3051 | |||||||||||||||||||||||||||||||||||
FailureQ | Basic | Queue name | SIMPLERROUTEDB_FAILURE This property is the queue that the message flow puts the message if the processing fails. |
||||||||||||||||||||||||||||||||||
KeyNotFoundQ | Basic | Queue name |
SIMPLERROUTEDB_KEYNOTFOUND This property is the local queue to which the message is put by the message flow. |
||||||||||||||||||||||||||||||||||
OrderClockQ | Basic | Queue name |
SIMPLERROUTEDB_ORDERCLOCK This property is the local queue to which the message is put by the message flow. |
||||||||||||||||||||||||||||||||||
SeniorStaffQ | Basic | Queue name |
SIMPLERROUTEDB_SNRSTAFF This property is the local queue to which the message is put by the message flow. |
||||||||||||||||||||||||||||||||||
DefaultQ | Basic | Queue name |
SIMPLERROUTEDB_DEFAULT This property is the local queue on which the message flow puts the message. |
Save the message flow.