DEALLOCATE DESCRIPTOR

The DEALLOCATE DESCRIPTOR statement deallocates an SQL descriptor.

This statement can only be embedded in an application program, SQL function, SQL procedure, or trigger. It cannot be issued interactively. It is an executable statement that cannot be dynamically prepared. It must not be specified in REXX.

Authorization

None required.

Syntax

               .-SQL-.              .-LOCAL--.
>>-DEALLOCATE--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name-><
                                    '-GLOBAL-'

Description

LOCAL: Specifies the scope of the name of the descriptor to be local to program invocation. The descriptor known in this local scope is deallocated.
GLOBAL: Specifies the scope of the name of the descriptor to be global to the SQL session. The descriptor known to any program that executes using the same database connection is deallocated.
SQL-descriptor-name: Names the descriptor to deallocate. The name must identify a descriptor that already exists with the specified scope.

Notes

Descriptor persistence: Local and global descriptors are also implicitly deallocated. For more information, see Descriptor persistence

Examples

Deallocate a descriptor called 'NEWDA'.

  EXEC SQL DEALLOCATE DESCRIPTOR 'NEWDA'