/usr/man/cat.l/deallocate.l.Z(/usr/man/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.

SQL - Language Statements         2003-11-02                     DEALLOCATE(l)