CA-L-Serv Commands › SQL Statements › OPEN Statement

OPEN Statement

The OPEN statement opens a cursor. When the OPEN statement is issued, the select criteria for the cursor (specified with the DECLARE CURSOR statement) is immediately executed.

Syntax

LSQL OPEN cursorname

Parameters

cursorname

Name of the cursor you are initiating (previously defined using the DECLARE CURSOR statement).

Note: The LSQL command that executes the OPEN statement must be issued from a CLIST or from a REXX procedure.

Example

To open the cursor that is named STATDOWN, issue this LSQL command from a CLIST:

LSQL OPEN STATDOWN