After you build a SQL statement, DB/Assist enables you to dynamically run the statement to display the result set and, if appropriate, commit or rollback the database changes. Running a statement dynamically may be useful if you want to test the results before compiling the statement as part of your ESL Application.

The text of the statement must be visible in the SQL Editor window in order to run it. Therefore, if the statement you want to run is not already open, open it as described in Opening an Existing SQL Statement.

You can run any of the following statement types that you have built in DB/Assist:

•Multi-row SELECT

•Single-row SELECT

•Searched UPDATE

•Searched DELETE

•INSERT

•Other