/usr/man2/cat.l/deallocate.l.Z(/usr/man2/cat.l/deallocate.l.Z)

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(l)].

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(l)], PREPARE [prepare(l)]

SQL - Language Statements         2005-11-05                      DEALLOCATE()