Previous Topic: ALTER TABLE StatementNext Topic: CREATE TABLE Statement

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

CLOSE Statement

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

Syntax

LSQL CLOSE cursorname

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 that is named CURSTAT, issue this LSQL command from a CLIST:

LSQL CLOSE CURSTAT