Deleting a Row

From the Connection window menu, select Connection / Create JDBC 4.0 Statement.

In the resultSetType drop-down list, select TYPE_SCROLL_SENSITIVE. In the resultSetConcurrency drop-down list, select CONCUR_UPDATABLE.

Click Submit; then, click Close.

Select Statement / Execute Stmt Query.

Specify the Select statement that you want to execute.

Click Submit; then, click Close.

Select Results / Inspect Results. The Inspect Result Set window is displayed.

Click Next. Current Row changes to 1.

Click Delete Row.

To verify the result, return to the Connection menu and select Connection / Load And Go. The Get Load and Go SQL window appears.

Specify the statement that you want to execute.

Click Submit; then, click Close.

The Connection window shows the row has been removed.