Compose Data Delete Expression editor

The Compose Data Delete Expression editor is used to add value to the data delete mappings that are already defined in the Mapping view. Use the editor to define more clearly how the values should be assigned and manipulated. You can also add other fields and apply different built-in and user-defined functions where required.

The editor is available in the Broker Application Development perspective; it is launched when you double-click a Target value field in the Overview pane.

Compose Data Delete Expression editor views

General Layout

The Mapping field shows the mapping information that is currently being edited. The Value of target field field shows all the output columns that are selected when the mapping was created.

Input area

The large white window contains the target value, or values, and can be manipulated using the editor tools described below. Here you can enter the WHERE clause of a Data Delete statement; for example, when a row should be deleted.

Operator buttons

The buttons on the right side of the screen contain the operators that can be inserted to the input area described above. Position the cursor where you want the operator to be inserted and click the appropriate button. The chosen operator is inserted at the cursor position.

Fields drop-down list

There are two drop-down lists available towards the bottom of the panel. The drop-down on the left shows Source fields by default. By clicking on the drop-down arrow, you can also select Output fields. When you click the button next to the drop-down button, a list of Source or Target fields is displayed. These can be dragged to their required position in the box above.

Functions drop-down list

The right-hand drop-down list shows String Functionsby default. By clicking on the drop-down arrow, you can also select other function types. Clicking on the arrow to the right shows all the functions that are available for the selected function type. To use one of these functions, highlight the field or fields to which you want to apply the function, select the function that you want to use, then drag and drop it onto the highlighted fields. (Alternatively, drag and drop the function where you want it and complete the necessary fields later.)

Compose Data Delete Expression editor toolbar

The Compose Data Delete Expression editor does not provide any additional icons and actions on the toolbar.

Related concepts
Mappings
Related tasks
Developing mappings