17.6. Operator rejection of the prepared operator

  <deallocate prepared statement> :: =
    DEALLOCATE PREPARE <SQL statement name> 

Comment:

The execution of this statement leads to the fact that the previously prepared SQL statement associated with the specified statement name is eliminated, and, accordingly, the name of the statement becomes undefined. If the prepared statement was a select statement, and by the time the DEALLOCATE statement was executed, there was an open cursor associated with the name of the prepared statement, then the DEALLOCATE statement returns an error code. If for the prepared sample operator there was an unopened cursor formed using the ALLOCATE CURSOR operator, then this cursor is eliminated. If the cursor was declared by the DECLARE CURSOR operator, then such a cursor changes to the state that existed before the execution of the PREPARE operator. If a prepared statement (dynamic DELETE or UPDATE) was associated with the cursor, then an implicit DEALLOCATE statement is executed for these statements.