declare cursor

Defines a cursor, by associating a select statement with a cursor name. You can use declare cursor with an archive database.

Syntax

declare cursor_name 
[semi_sensitive | insensitive] [scroll | no scroll] [release_locks_on_close]
	cursor for select_statement 
	[for {read only | update [of column_name_list]}]

Parameters

Examples

Usage

Standards

ANSI SQL – Compliance level: Entry-level compliant.

Permissions

No permission is required to use declare cursor.

Related reference
open