close

Description
            Deactivates a cursor.

Syntax
            close cursor_name

Parameters
            cursor_name
              is the name of the cursor to close.

Examples
            Closes the cursor named authors_crsr:

                 close authors_crsr

Usage
            •    The close command essentially removes the cursor’s result set. The cursor
                 position within the result set is undefined for a closed cursor.
            •    Adaptive Server returns an error message if the cursor is already closed or
                 does not exist.