Syntax options:

       EXECUTE
       NOEXECUTE
       NO EXECUTE

    Instructs SQL whether to execute the data manipulation statements
    you issue in an interactive SQL session.

    You can use the NOEXECUTE option in conjunction with the
    SET FLAGS to examine the estimated cost and access strategy
    associated with a query. If you specify SET NOEXECUTE, SQL
    displays the access strategies without executing the query. SQL
    also allows you to specify NO EXECUTE (as two words); this has
    the same meaning as NOEXECUTE.

    If you do not specify EXECUTE or NOEXECUTE, the default is
    EXECUTE.

    The SET TRANSACTION statement is not executed when SET NO EXECUTE
    is active. Start or declare a transaction prior to using SET NO
    EXECUTE.