Apache Hive : HPL/SQL - CLOSE Statement

CLOSE statement closes a cursor.

Syntax:

CLOSE cursor_name;

Parameters:

Examples:

DECLARE id INT;
DECLARE cur CURSOR FOR 'SELECT id FROM db.orders';
OPEN cur;
FETCH cur INTO id;
CLOSE cur;

Compatibility: Oracle, IBM DB2, Teradata, SQL Server, PostgreSQL, MySQL.

See also:

• DECLARE CURSOR
• OPEN
• FETCH
• SQLCODE