Deactivates a cursor.
If the cursor specified by cursor_name contains references to proxy tables, Adaptive Server notifies Component Integration Services to close and deallocate its remote cursors for those tables.
Component Integration Services uses Client-Library to manage cursor operations to a remote server. When Component Integration Services receives a close command, it 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 close a remote cursor for each server represented by the proxy tables.
deallocate cursor, declare cursor, fetch, open in this chapter.
close in the Adaptive Server Reference Manual.