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

Previous Topic: INSERT Statement

Next Topic: SELECT 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

Operand

Explanation

cursorname

The 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 named STATDOWN, issue this LSQL command from a CLIST:

LSQL OPEN STATDOWN