WebSphere Message Brokers
File: ag11360_
Writer: John Morris-Smith

Task topic

This build: July 31, 2007 21:29:48

Debugging ESQL

Before you start

To complete this task, you must have completed the following tasks:

When message flow processing has paused at a breakpoint in source code within a node that contains ESQL code (a Compute, Filter, or Database node), you can browse ESQL variables in the Variables view in the Debug Perspective, and change their associated data values. You can also set breakpoints on lines in the ESQL code. See the following sections for further details:

When you finished working with the ESQL code and variables, message flow processing continues until the next breakpoint that is set in the logical processing of the current message . If there is no further breakpoint at which the flow instance can pause, the flow instance runs to completion and is removed from the Debug view.

If you have now completed debugging this message flow, you can remove the breakpoints, or end the debug session:

Working with ESQL variables

  1. Switch to the Debug perspective.
  2. Open the Variables view. Variables are shown in a tree, using the symbol Variable.
  3. To work with a variable, right-click it and select an option from the pop-up menu.

For example, if you have declared the following ESQL variables:

DECLARE myInt INT 0;
DECLARE myFloat FLOAT 0.0e-1;
DECLARE myDecimal DECIMAL 0.1;
DECLARE myInterval INTERVAL DAY TO MONTH;

you can update these values in the debugger. However, you cannot update the message trees, or REFERENCE variables.

Using breakpoints on ESQL code lines

  1. Switch to the Debug perspective.
  2. Open the ESQL editor.
  3. Right-click a line where a breakpoint can be set. You cannot set a breakpoint on a comment line or a blank line.
  4. Select from the menu to create, delete, or restrict the breakpoint, in a similar way to normal debugger breakpoints, as described in Working with breakpoints.

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:29:48

ag11360_ This topic's URL is: