Deallocates a SQL descriptor.
exec sql deallocate descriptor descriptor_name;
The name of the SQL descriptor that contains information about the dynamic parameter markers or return values in a prepared statement.
exec sql begin declare section;
CS_INT numcols, colnum;
exec sql end declare section;
...
exec sql allocate descriptor big_desc
with max 1000;
exec sql prepare dynstmt from "select * from
huge_table";
exec sql execute dynstmt into sql descriptor
big_desc;
exec sql get descriptor :numcols = count;
for (colnum = 1; colnum <= numcols; colnum++)
{
exec sql get descriptor big_desc
...
}
exec sql deallocate descriptor big_desc;
...
If you attempt to deallocate a SQL descriptor that has not been allocated, an error occurs.
allocate descriptor
