Makes a cursor inaccessible and releases all memory resources committed to that cursor.
deallocate cursor cursor_name
Usage
If the cursor specified by cursor_name contains references to proxy tables, Adaptive Server notifies Component Integration Services to deallocate its remote cursors for those tables.
If the remote cursor is not closed, Component Integration Services closes and deallocates it. If the remote cursor is already closed, no additional actions are taken.
Component Integration Services uses Client-Library to manage cursor operations to a remote server. When Component Integration Services receives a deallocate cursor command and the cursor has not been explicitly closed with a close command, Component Integration Services uses the following Client-Library functions to interact with the remote server:
ct_cursor(command, CS_CURSOR_CLOSE, NULL, CS_UNUSED, NULL, CS_UNUSED, CS_UNUSED)
ct_cursor(command, CS_CURSOR_DEALLOC, NULL, CS_UNUSED, NULL, CS_UNUSED, CS_UNUSED)
If the cursor contains references to more than one proxy table, Component Integration Services must deallocate a remote cursor for each server represented by the proxy tables.
See Also
close, declare cursor, fetch, open in this chapter.
deallocate cursor in the Adaptive Server Reference Manual.
