close

Deactivates a cursor.

Syntax

close cursor_name

Parameters

Examples

Usage

  • The close command essentially removes the cursor’s result set. The cursor position within the result set is undefined for a closed cursor.

  • The SAP ASE server returns an error message if the cursor is already closed or does not exist.

Standards

ANSI SQL – Compliance level: Entry-level compliant.

Permissions

No permission is required to use close.

Related reference
deallocate cursor
declare cursor
fetch
open