VMS Help  —  SQLPRE72  Arguments  compound-statement
    A statement that can contain multiple SQL statements in an SQL
    module procedure or in an embedded SQL procedure.

    An embedded procedure that contains a compound statement is
    called an embedded multistatement procedure. SQL supports a
    restricted subset of SQL statements in a compound statement
    embedded in a host langauge program. Refer to the Oracle Rdb
    SQL Reference Manual for a list of valid SQL statements allowed
    in a compound statement.

    Compound statements can also include program-like, flow-
    of-control statements (IF, LOOP, CASE, LEAVE), transaction
    management statements (COMMIT and ROLLBACK), a variable
    declaration statement (SET assignment), a cursor-processing
    statement (FOR), and a procedure-debugging statement (TRACE).

    See the Oracle Rdb SQL Reference Manual for a complete
    description of a compound statement.
Close Help