OPEN

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)
OPEN		YES

Note: YES indicates a valid execution method for this statement.For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

The OPEN statement opens a cursor so that it can be used to fetch rows from its result table.

In an application program, a DECLARE CURSOR statement must have corresponding OPEN, FETCH and CLOSE statements for the execution of the OPEN to proceed without error.

Following is the syntax diagram for the OPEN statement:

►►─ OPENcursor-name ─┬──────────────────────────────────────┬─────────────────►◄
                     │           ┌─ , ─────────────┐        │
                     └─ USING ─┬─▼─ host-variable ─┴──────┬─┘
                               └─ DESCRIPTORdescrpt-name ─┘