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

  simple-statement =

  ----> SQL statement ---->

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;