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 CURSOR ─┬─────────────┬─ FOR ───────────────────────►
                              └─ WITH HOLD ─┘

 ►─┬─ select-statement ─┬──────────────────────────────────────────────────►◄
   └─ statement-name ───┘