deallocate

a b c d e f g h i j k l m n o p q r s t u v w x y z _
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	deal-
       located 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.



SQL - Language Statements	  2008-01-03			 DEALLOCATE()