1  Simple_Statement
   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.
 

2  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)0simple-statement =         
                            
 qqqq> SQL statement qqqq>  

 

2  Arguments
 

3  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.
 

2  Examples

   Example 1: A simple statement using interactive SQL

   SQL> ALTER DATABASE FILENAME mf_personnel
   cont> JOURNAL IS DISABLED;