Includes a single SQL statement in a module procedure or in
an embedded host language program. The statement can include a
single executable SQL statement. A module procedure or embedded
procedure that contains a simple statement is called a simple-
statement procedure.
1 – Environment
A simple statement is valid either in a procedure of an SQL
module file or in an embedded host language program prefixed
by the keywords EXEC SQL:
o Module SQL
See the Oracle Rdb SQL Reference Manual for information about
using simple statements in module procedures in an SQL module
file.
o Embedded SQL
See the Oracle Rdb SQL Reference Manual for information
about using simple statements in embedded procedures in host
language programs.
2 – Format
(B)0[m[1msimple-statement = [m [1m [m [1mqqqq> SQL statement qqqq> [m
3 – Arguments
3.1 – SQL statement
Specifies a single executable SQL statement.
Executable SQL statements undergo processing during module
compile time but do not execute until the program runs. SQL
executes the simple statement when the procedure in which it
is embedded is called by a host language module. (Nonexecutable
SQL statements are those that SQL processes completely when it
compiles an SQL module but are not executed at run time.) See the
Oracle Rdb SQL Reference Manual for information about which SQL
statements are executable.
The SQL statement must use names specified in the procedure's
formal parameters wherever it refers to parameters.
4 – Examples
Example 1: A simple statement using interactive SQL
SQL> ALTER DATABASE FILENAME mf_personnel
cont> JOURNAL IS DISABLED;