Calling .NET assemblies from ESQL

Use the CREATE FUNCTION or CREATE PROCEDURE statements in a node that supports ESQL.

About this task

You can call .NET code from any of the nodes that support ESQL; see ESQL overview.
Tip: To associate .NET code with an ESQL node, drag an existing .NET assembly onto the canvas, or a node that supports ESQL, and then follow the prompts.

Procedure

  1. In Microsoft Visual Studio, create and build your project.
  2. In the IBM Integration Toolkit, drag one of the nodes that support ESQL onto the message flow.
  3. Double-click the node to open the ESQL editor.
  4. Define a CREATE FUNCTION or CREATE PROCEDURE statement, specifying the language as either .NET or CLR.
    See CREATE FUNCTION statement and CREATE PROCEDURE statement for details, including examples.