SQL Update
The SQL Update element is used for updating data in Db2. It can contain a number of SQL statements for inserting, updating and deleting rows. It can even be used to create and drop tables.
Add SQL Update to the Test Scenario by dragging it from the tool palette. This opens the Insert a new SQL Update element popup. Here are the fields available when setting up this element:
- Label - the label name you want assigned. This is only used to present in the user interface and in the execution log file.
- Description - an optional description of the Test Element.
- SQL Updating statement - All SQL statements are written in the Statement element that is using a CDATA to preserve statements for an greater visual experience when looking at the source.
- OK / Cancel - click on OK to save your element.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*