CLEAR Statement [Interactive SQL]

Closes any open result sets in Interactive SQL (dbisql).

Syntax

CLEAR

Usage

Closes any open result sets and leaves the contents of the SQL Statements pane unchanged

Side effects:

The CLEAR statement closes the cursor associated with the data being cleared.

Standards

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not applicable.

Permissions

None

Parent topic: SQL Statements
Related reference
EXIT Statement [Interactive SQL]