Depending on the type of statement you are running and whether executing the statement would change the database, one or more of the following DB/Assist components can appear when you run the statement dynamically:

•Result Set window

•Input Values dialog box

•Run Complete dialog box

The flowchart below gives an overview of how to run different types of SQL statements. The sections following the flowchart provide information about using the Result Set window, Input Values dialog box, and Run Complete dialog box as part of these procedures.

You cannot run positioned UPDATE and positioned DELETE statements dynamically in DB/Assist. To run these statements, they must be part of a working ESL application. (For a sample ESL program that shows how to use positioned UPDATE and positioned DELETE statements, see Sample Program for Positioned SQL.)

Procedures for Running SQL Statements