2. Writing Scripts and Procedures : Scripts : Statements in Scripts
 
Share this page                  
Statements in Scripts
Scripts can contain any mixture of 4GL statements and SQL statements acceptable to OpenROAD. These statements enable OpenROAD to perform a wide variety of tasks:
Declaration and assignment
These statements let you define variables and assign values to them.
Data management
These statements, such as select, insert, delete, and update, let you query and update the database.
Loop control
These conditional statements, including for, if, while, continue, and endloop, let you control the processing flow within a script, event block, or procedure.
Program flow control statements
These statements let you control the basic flow of the application by calling frames, procedures, operating system, or even another Ingres tool.
For detailed descriptions of SQL and all OpenROAD statements, see the Language Reference Guide.