Create and configure message flows that respond to events in a database.
Before you start:
Ensure that your database is configured to record events (uses an event table), and that you know how to query those events. For information about event tables and triggers, see the DatabaseInput Node sample. You can view information about samples only when you use the product documentation that is integrated with the IBM Integration Toolkit or the online product documentation. You can run samples only when you use the product documentation that is integrated with the IBM Integration Toolkit.
If you use DB2® on z/OS®, your user ID (or your user group) requires permission to perform a SELECT on SYSIBM.SYSJAROBJECTS.
When you drag a DatabaseInput node onto the canvas, IBM Integration Bus creates an ESQL module that contains boilerplate text. To configure the DatabaseInput node, modify the statements in that module to suit your requirements.
When you double-click the node to modify the ESQL code, the editor displays the Database Event Design tab for the module. Complete the mandatory fields and then click Generate query. To view or modify the code, click the Source tab. Code that has been generated is clearly marked by color-coded --@!{ and --@!} comments. Any changes that you make within these comments are lost if you regenerate the code.
Configure your target system to receive the message.