DECLARE CURSOR

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
DECLARE CURSOR		YES

Note: YES indicates a valid execution method for this statement.

Note: This statement cannot be executed interactively. Use the SELECT statement instead (see SELECT). For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

The DECLARE CURSOR statement defines a cursor.

Following is the syntax diagram for the DECLARE CURSOR statement:

►►─ DECLARE cursor-name ─┬─ NO SCROLL ◄ ──────────────────────────┬─ CURSOR ──►
                         ├─ ASENSITIVE ◄ ──────────────┬─ SCROLL ─┘
                         ├─ INSENSITIVE ───────────────┤
                         └─ SENSITIVE ─┬─ DYNAMIC ◄ ─┬─┘
                                       └─ STATIC ────┘
►──┬─────────────┬─ FOR ─┬─ select-statement ─┬──────────────────────────►◄
   └─ WITH HOLD ─┘       └─ statement-name ───┘