DEALLOCATE()			 SQL Commands			  DEALLOCATE()



NAME
       DEALLOCATE - deallocate a prepared statement


SYNOPSIS
       DEALLOCATE [ PREPARE ] plan_name


DESCRIPTION
       DEALLOCATE  is  used to deallocate a previously prepared SQL statement.
       If you do not explicitly deallocate a prepared statement, it is deallo-
       cated when the session ends.

       For more information on prepared statements, see PREPARE [prepare(7)].

PARAMETERS
       PREPARE
	      This key word is ignored.

       plan_name
	      The name of the prepared statement to deallocate.

COMPATIBILITY
       The  SQL	 standard  includes a DEALLOCATE statement, but it is only for
       use in embedded SQL.

SEE ALSO
       EXECUTE [execute(7)], PREPARE [prepare(l)]



SQL - Language Statements	  2010-12-14			  DEALLOCATE()