In addition to the four primary data manipulation statements (select, update, insert, and delete), OpenROAD lets most SQL statements to be used directly in your 4GL scripts. For a list of these statements, see the Language Reference Guide online help.

To use SQL statements that you cannot code directly in a 4GL script, such as the statement for creating a database procedure, OpenROAD provides the execute immediate statement. For more information about this statement, see How You Can Use the Execute Immediate Statement.

The following subsections describe how to use the select, update, insert, and delete statements in your OpenROAD applications.