This condition is shown in line 35, where if the column is being sorted for a consecutive time and the previous direction was upward, it must be switched to downward sorting.

In the case of the DB2 example in the left column of Table 3, if a particular SQL statement fails and generates an error, control is passed to the condition handler.

The variable association dialog is launched by clicking the value column of the condition row, and selecting Use a variable to return the value in the drop-down box.