Run an SQL statement

Use the Run push button in the SQL code view to run an SQL statement. Use caution when running an INSERT, UPDATE, or DELETE statement from the SQL Assist environment. Running an INSERT, UPDATE, or DELETE statement will make changes to the database you are connected to.

To run a SELECT statement:

  1. Click Run in the SQL code view. If the statement contains host variables, a window opens where you can specify values for the host variables. The SELECT statement runs on the database to which you are currently connected. A window opens displaying the result set.
  2. Click OK to close the window.

To run an INSERT, UPDATE, or DELETE statement:

  1. Click Run in the SQL code view. If the statement contains host variables, a window opens where you can specify values for the host variables. If all required fields have been completed, the INSERT, UPDATE, or DELETE statement runs on the database to which you are currently connected. A confirmation window opens displaying the number of rows that were affected in the table that you selected for the INSERT, UPDATE, or DELETE statement.
  2. Click OK to close the window.