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

Previous Topic: ALTER TABLE Statement

Next Topic: CREATE TABLE Statement

CLOSE Statement

The CLOSE statement closes a cursor. It is important to close a cursor to release resources.

Syntax

LSQL CLOSE cursorname

Operand

Explanation

cursorname

The name of the cursor you are closing.

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

Example

To close the cursor named CURSTAT, issue this LSQL command from a CLIST:

LSQL CLOSE CURSTAT