How do I program message flows?
New users: Use the links in this topic to get information about the concepts and tasks associated with programming message flows.
New users: Use the links in this topic to get information about the concepts and tasks associated with programming message flows.
Follow this link for instructions on how to create a graphical data map in the Integration Development perspective. You can also create a graphical data map from the Mapping node; see Creating a message map from a Mapping node.
You create and modify mappings in the Graphical Data Mapping editor. Use this link to discover information about the Graphical Data Mapping editor.
When you configure graphical data mappings, you can drag content from a source to a target. The source can be a message, a database, or both, and the target can be messages, database tables, or both. If your target is a database, you can select the database operation (for example: insert, update, or delete) that you want to perform on the table. You can set the value for your target to be a constant, or you can use a function or expression to produce the value. Additionally, you can configure conditional mappings to set different values for targets that are based on the content of the sources, and to handle repeating elements in sources and targets. Follow this link to discover more about graphical data mappings.
When you use an expression to set the value of a target in a message map, the expression must be in XPath format.
Use this link to discover more about the XPath syntax that is used in message maps.
Use this link to discover more about the type of functions that you can use in your graphical data maps.
To discover more about XPath, follow this link to the W3C recommended XPath 1.0 query syntax reference document. This link works only if you have an active internet connection.
Extended Structured Query Language (ESQL) is a programming language that is based on Structured Query Language (SQL), which is commonly used with relational databases such as IBM® DB2®. ESQL extends the constructs of the SQL language to provide support for you to work with both message and database content. ESQL can be used with the Compute, Database, and Filter nodes.
The ESQL code for each of your nodes is contained within a module in an ESQL file. Use this topic to discover how to create an empty ESQL file in your integration project. Alternatively, you can select Open ESQL to create an ESQL file when you configure the first node in a message flow that uses ESQL. This action creates an ESQL file with skeleton ESQL code for a module that is associated with the selected node. You can also select an ESQL module for a node from a different integration project by creating a project reference; see Referencing resources in other libraries.
You can create and modify your ESQL code in the ESQL editor. You can change the way that code is displayed in the ESQL editor, and modify how the ESQL editor validates code, by changing your ESQL preferences.
Follow this link to get an overview of how to create ESQL for your node, including more information about the differences between the skeleton ESQL code that is generated for the modules that are associated with the Compute, Database, and Filter nodes.
Follow this link to discover how to modify the skeleton ESQL module code.
Discover how to save your ESQL file.
Follow this link to get introductory information about writing ESQL code for your message flows. Discover how to manipulate the message tree, transform data, access databases, and work with messages from different message domains using ESQL.
Use the following the links to get concept and reference information about the ESQL language:
You can create a Java™ class file for a JavaCompute node and code Java functions to tailor the behavior of the node. You can add any valid Java code to your JavaCompute nodes and use the Java user-defined node API to process messages. You manage Java files through the Java perspective.
You can use the JavaCompute node to examine the content of an input message, transform a message, and build new messages. Follow this link to discover how to use and configure the JavaCompute node in your message flows.
Discover how to create a Java class file using the JavaCompute node wizard. The JavaCompute node wizard creates a Java class with skeleton Java code that is based on the options that you select in the wizard. You can then modify the skeleton code to perform your own processing.
You can modify existing Java code that you have created in a Java Project.
Discover how to save your Java file.
Get introductory information about writing Java code for your message flows, including how to manipulate the message tree, access databases, handle errors, and access integration node properties.
Get a list of concept, task, and reference topics that relate to editors and views for working with Java. This link works only if you are accessing this documentation from the IBM Integration Toolkit.
You can use code assist to provide a list of available command completions that you can select to insert into the editor. You can also use command assist to access Javadoc information about code in the Java editor. This link works only if you are accessing this documentation from the IBM Integration Toolkit.
Discover how to include references to other Java projects and JAR files in your JavaCompute node code.
Follow this link to the Java API for the IBM Integration Bus classes for creating a Java user-defined node, which you can also use to code your JavaCompute node.
Follow this link to discover how to use and configure the XSLTransform node to transform an XML message into another form of XML.
To discover more about XML Transformations, follow this link to the W3C specification of the syntax and semantics of the XSL Transformations language for transforming XML documents into other XML documents.
On Windows, use .NET assemblies to create, modify, and route messages. You can call .NET assemblies from a .NETCompute node. Using ESQL, you can also call assemblies from a Compute node. For a high-level overview about what you can do with .NET, see Using .NET.
Follow this link for an overview of XPath, and how you can use XPath with nodes.
You can use the XPath Expression Builder to add XPath expressions to your node properties. Follow this link for information about how to use the XPath Expression Builder.