SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

3-16

DEALLOCATE DESCRIPTOR Statement

C Examples of DEALLOCATE DESCRIPTOR

COBOL Examples of DEALLOCATE DESCRIPTOR

The DEALLOCATE DESCRIPTOR statement deallocates an SQL descriptor area used

for storing information necessary for the execution of dynamic SQL statements. The

descriptor area was previously allocated with the ALLOCATE DESCRIPTOR

statement.

Use DEALLOCATE DESCRIPTOR only in embedded SQL programs in C or COBOL.

descriptor-name

is a value-specification—a character literal or host variable with character

data type. When DEALLOCATE DESCRIPTOR executes, the content of the host

variable (if used) gives the name of the descriptor area.

GLOBAL | LOCAL

specifies the scope of the allocated descriptor area. The default setting is LOCAL.

A GLOBAL descriptor area is available to the SQL session. A LOCAL descriptor

area is available only to the module or compilation unit in which it was allocated.

An SQL descriptor area must be currently allocated whose name is the value of

descriptor-name and whose scope is the same scope as specified in the

DEALLOCATE DESCRIPTOR statement for the area.

DEALLOCATE DESCRIPTOR descriptor-name

descriptor-name is:

[GLOBAL | LOCAL] value-specification

C/COBOL